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

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.

  • aryehleib
    a year ago

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

Topics
Migration & ModernizationDatabaseAnalytics
Tags
AWS Database Migration ServicePostgreSQLAmazon Relational Database Service
Language
English
aryehleib
asked a year ago549 views
1 Answer
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.

rePost-User-9052262
answered a year 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

Relevant content