Message-ID: <gh-pgjdbc-pgjdbc-2311-c2611356076@github.com>
From: "beanww (@beanww)" <noreply+beanww@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 24 Jan 2025 01:32:55 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #2311: Why is client time zone not configurable?
In-Reply-To: <gh-pgjdbc-pgjdbc-2311@github.com>
References: <gh-pgjdbc-pgjdbc-2311@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: beanww
X-GitHub-Comment-Id: 2611356076
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 2311
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/2311#issuecomment-2611356076
Content-Type: text/plain; charset=utf-8

I use flink to sync records from postgres to postgres, column typs is timestamptz to timestamptz, 
source connector is flink-sql-connector-postgres-cdc-3.2.1.jar
sink connector is flink-connector-jdbc_2.12-1.14.6.jar
jdbc driver is postgresql-42.7.5.jar
and flink is not support timestamp with time zone in postgres-connector now, so the source->sink type mapping is timestamp,eg:
created_time timestamp
when I do not set flink jvm user.timezone=UTC,  the records syncronized to sink database is wrong, diff is 8 hours that is my OS timezone
So I have 2 question ,  
1. what's difference between flink-sql-connector-postgres-cdc-3.2.1.jar and  flink-connector-jdbc_2.12-1.14.6.jar? if both are pg connection from jdbc, why the timezone is difference?
2. Can this be a reason to add timezone prop from JDBC connection string? just like mysql?
I have tried this method, but sames not working:
jdbc:postgresql://xxx/db?options=-c%20TimeZone%3DUTC