Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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
    2 anni fa

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

Argomenti
Migrazione e modernizzazioneDatabaseAnalisi
Tag
Servizio di migrazione dei database AWSPostgreSQLAmazon Relational Database Service
Lingua
English
aryehleib
posta 2 anni fa561 visualizzazioni
1 Risposta
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
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente