pgjdbc/pgjdbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: beanww (@beanww) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #2311: Why is client time zone not configurable?
Date: Fri, 24 Jan 2025 01:32:55 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
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
view thread (57+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: github://pgjdbc/pgjdbc
Cc: [email protected], [email protected]
Subject: Re: [pgjdbc/pgjdbc] issue #2311: Why is client time zone not configurable?
In-Reply-To: <<[email protected]>>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox