Is supported Timestamptz datatype in DMS postgres replication?

0

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.DataTypes

This document shows that timestamps with timezone is not supported in DMS postgres.
But I tried to replicate a database whose table which includes timestamptz column and it replicated correctly.
Could you tell me why replication was successful?

This is my configuration of this task.

*DMS replication instance

  • engine version: 3.1.4
    *Endpoint(source)
  • RDS PostgreSQL 9.4
  • The source table schema is like this:
    Table "public.source_table"
    Column | Type | Modifiers
    --------------------------------------------------
    set_time | timestamp with time zone | not null
    channel_1 | numeric(24,8) |
    channel_2 | numeric(24,8) |
    channel_3 | numeric(24,8) |
    ...
    Indexes:
    "source_table_pkey" PRIMARY KEY, btree (set_time)
    *Endpoint(target)
  • Aurora PostgreSQL 10.7
  • The target table which has timestamptz was created in advance and use "TargetTablePrepMode":"TRUNCATE_BEFORE_LOAD" mode.
    *Replication task
  • MigrationType: full-load-and-cdc
  • TableMappings: '{
    "rules":[{
    "rule-type":"selection",
    "rule-id":"1",
    "rule-name":"1",
    "object-locator":{
    "schema-name":"public",
    "table-name":"%"
    },
    "rule-action":"include",
    "filters":[]
    }]
    }'

Edited by: sabmeua on Aug 29, 2019 7:42 PM

Edited by: sabmeua on Sep 4, 2019 9:06 PM

sabmeua
已提问 5 年前875 查看次数
2 回答
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.

VS007
已回答 4 年前
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

sabmeua
已回答 4 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则