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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南