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년 전877회 조회
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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠