2 Answers
- Newest
- Most votes
- Most comments
0
Hi @sabmeua,
Did you manage to find an answer to your question? We have the same question. It would be great to know how you resolved this.
Thanks.
answered 4 years ago
0
Thanks for replying.
Unfortunately, I haven't gotten clear answer yet.
But, currently timestamptz is written that partially migrable in the document.
This is my case, the migration from version 9.4 to 10.7 involved a logical replication is used.
For logical replication, if the time zone between the subscriber and the source are the same, the migration of timestamptz is possible.
If the time zones are different, pglogical will not be able to reflect the time zone correctly.
I believe that "partially" means that.
Edited by: sabmeua on Apr 16, 2020 6:21 PM
answered 4 years ago
Relevant content
- asked 2 years ago
- Accepted Answerasked 2 years ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated a year ago