teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

2

内容の追記

2018/12/06 00:26

投稿

退会済みユーザー
title CHANGED
File without changes
body CHANGED
@@ -3,6 +3,16 @@
3
3
  **解決したい問題**
4
4
  下記エラーの対処方法をご教授いただきたいです。
5
5
 
6
+ **一応の解決方法**
7
+ 下記で一応動きました。。
8
+ ```sql
9
+ \encoding utf8
10
+
11
+ drop table access_log;
12
+ \i src/access_log.ct
13
+ \copy access_log from 'src/access_log.bz2.csv' with csv header null '' delimiter ',' quote e'"';
14
+ ```
15
+
6
16
  **エラー内容**
7
17
  ```log
8
18
 
@@ -77,4 +87,7 @@
77
87
 
78
88
  **環境**
79
89
  * Windows10
80
- * PostgresSQL 9.4
90
+ * PostgresSQL 9.4
91
+
92
+ **参考サイト**
93
+ [PostgreSQLのcopyではまった](http://deta.hateblo.jp/entry/2015/09/10/094157)

1

文章の変更

2018/12/06 00:26

投稿

退会済みユーザー
title CHANGED
File without changes
body CHANGED
@@ -18,6 +18,18 @@
18
18
  16632811:hoge.fuga.net.mx~-~-~23/Sep/2018:10:16:30 +0900~GET~/index.php?q=hoge_fuga&search_id=1234"~200~144241~-~-
19
19
  16632832:hoge.fuga.net.mx~-~-~23/Sep/2018:10:16:32 +0900~GET~/index.php?q=hoge_fuga&search_id=1234&page=piyo~200~331344~-~-
20
20
 
21
+ $ tail -10 access_log.tsv
22
+ m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&action=ghi&q%3Dabc%26id%3D123&text=&_=123~200~38~https://www.fuga.com/index.php?q=abc&id=1234~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
23
+ m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&action=def~200~56~https://www.fuga.com/~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
24
+ m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&q=abc&id=123~200~306~https://www.fuga.com/~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
25
+ 1-2-3.hoge.fuga.ad.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?q=123&search=%AB%BC%DF~200~44979~https://www.google.com/~Mozilla/5.0 (Linux; Android 8.1.0; F-04K Build/V18R067C) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Mobile Safari/537.36
26
+ 123.hoge.fuga.ne.jp~-~-~01/Oct/2018:01:59:59 +0900~GET~/index.php?&q=def&search=~200~51~https://www.hoge.net/index.php?q=123~Mozilla/5.0 (iPhone; CPU iPhone OS 12_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16A366 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
27
+ 123.hoge.fuga.ne.jp~-~-~01/Oct/2018:01:59:59 +0900~GET~/index.php?&q=def~200~56~https://www.hoge.net/~Mozilla/5.0 (iPhone; CPU iPhone OS 12_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16A366 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
28
+ Oct 1 02:00:00 svr1 newsyslog[50902]: logfile turned over
29
+ hgoe.fuga.co.jp~-~-~01/Oct/2018:02:00:00 +0900~GET~/blog/?q=1~200~19843~-~-
30
+ hoge1234567890.fuga.net~-~-~01/Oct/2018:02:00:00 +0900~GET~/index.php?q=abc&page_id=1234&gclid=ABCDEFG~200~47956~-~Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.1.50 (KHTML, like Gecko) GSA/59.0.213668279 Mobile/14D27 Safari/602.1
31
+ .
32
+
21
33
  ```
22
34
 
23
35
  **バッチファイル**