Database Migration Service - CDC with pglogical

Question

We are setting up ongoing cdc replication with DMS on an RDS Postgresql 12 instance.  I read the following in [this article](https://medium.com/helpshift-engineering/migrating-postgresql-databases-using-aws-dms-e91cf26fa6e), 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.

Answer

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.

Database Migration Service - CDC with pglogical

相關內容