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?

已提问 2 年前241 查看次数
1 回答
0

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

已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则