By using AWS re:Post, you agree to the Terms of Use

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

asked 3 years ago54 views
2 Answers
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 2 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 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions