Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re: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
    3 years ago

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

Topics
AnalyticsMigration & ModernizationDatabase
Tags
AWS Database Migration ServiceAmazon Relational Database ServicePostgreSQL
Language
English
asked 3 years ago1.3K 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.

answered 3 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.

Relevant content