The time difference hours has disappeared with `TIMESTAMP WITHOUT TIME ZONE`
susumuf opened this issue · 0 comments
susumuf commented
I tried to record nginx access logs in local time(asia/tokyo, UTC+9), but when I wrote to 'TIMESTAMP WITHOUT TIME ZONE', the time difference disappeared.
On the other hand, if you write to TIMESTAMP WITH TIME ZONE
, the time difference will be reflected and the data will be recorded correctly.
Would someone expert help me out ? or any escape ?
I used this env and config as blow;
fluent.conf
<source>
@type tail
path /var/log/nginx/access.log
pos_file /var/log/nginx/nginx-access.log.pos
tag nginx-access
<parse>
@type nginx
</parse>
</source>
<match nginx-access>
@type sql
host db
port 5432
database fluentd
adapter postgresql
username fluentd_rw
password fluentd
<inject>
time_key time
time_type string
timezone Asia/Tokyo
</inject>
<table>
table nginx_access
column_mapping 'time:stamp,remote:remote,host:host,method:method,path:path,code:code,size:size,referer:referer,agent:agent,http_x_forwarded_for:http_x_forwarded_for'
</table>
</match>
env:
fluent-gem list as below;
fluent-config-regexp-type (1.0.0)
fluent-plugin-rewrite-tag-filter (2.4.0)
fluent-plugin-sql (2.3.0)
fluentd (1.16.2)
pg (1.5.4)