En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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
    il y a 2 ans

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

Sujets
Migration et modernisationBase de donnéesAnalytique
Balises
Service de migration de base de données AWSPostgreSQLAmazon Relational Database Service
Langue
English
aryehleib
demandé il y a 2 ans561 vues
1 réponse
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
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents