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)
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
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)