RDS PostgreSQL cascading replication for Fivetran integration (logical replication not working on replica)

0

I'm trying to setup cascading replication from RDS PosgresSQL instances, using logical replication (test_decoding), that will be used by Fivetran. As I don't want to connect any 3-rd party tools to Primary database, I'm trying to setup logical replication on replica, so the flow will look like:

Primary (RDS.Postres with HA) -> Replica (RDS.Postres RO replica) --(test_decoding)--> Fivetran.

I've followed the steps from this article: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.LogicalReplication (setup parameter & restart database).

Seems logical replication was successfully enabled on Primary (wal_level = logical) but the same steps on replica are not working (wal_level = replica). I've tried with different PG versions as there was a mention, that cascading option is available since 14.1 - I'm currently using 14.2 with no luck.

Is there anything more I need to enable in order to get this working? Or is such design not supported at all on Manged RDS PostgresSQL Replica?

1 Antwort
0

Did you also enable the wal_level = logical on the replica?

beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen