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 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
Oracle materialized view replication to postgres using DMS CDCasked 2 months ago
Is supported Timestamptz datatype in DMS postgres replication?asked 3 years ago
Using DMS CDC for Oracle to Postgresasked 3 months ago
CDK DMS replication instanceAccepted Answerasked 2 years ago
Need to use Postgres 14.3 as source in DMSasked 2 months ago
Applying column filters in DMS Task for source MongoDB and target Postgres
RDS Postgres Logical replication access to essential table deniedAccepted Answerasked 4 years ago
DMS task fails when Postgres DateStyle parameter is not ISOAccepted Answerasked 4 months ago
DMS Migration MongoDB source and RDS Postgres as destinationAccepted Answer
DMS replicationasked 2 months ago