Database Migration Service - CDC with pglogical

0

We are setting up ongoing cdc replication with DMS on an RDS Postgresql 12 instance. I read the following in this article, written about a year ago:

One of our tasks failed in the CDC stage after running for a few days. As per AWS support, there’s a known issue with DMS and pglogical and we were advised to use test_decoding for the failed task. Following that we chose test_decoding for rest of the dbs.

Has this known issue been resolved? All other things being equal, it seems that pglogical is preferred.

  • I see now that test_decoding extension is not supported on RDS PostgreSQL version 12 and higher

1 Antwort
0

Not sure about pglogical preference but we are using test_decoding over last 6 months and things look fine from data replication front. Source is AWS RDS/Aurora postgres instances, and target is s3.

beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen