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
preguntada hace 5 años877 visualizaciones
2 Respuestas
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
respondido hace 4 años
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
respondido hace 4 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas