CODEWITHSUNDEEP
postgresqlamazon-web-servicesamazon-rdsreplicationlogical-replication
mbsouksu
mbsouksu

Reputation: 108

Logical Replication from a AWS RDS Postgres Read Replica

Basicaly we have a primary Postgres Database A in the AWS RDS and we also have a replica of it, let's call it B. There is a replication process from A ---> B on AWS side itself. And I have another database Instance, let's call it C. I am trying to enable logical replication from B ---> C. As a one step, I change the parameter of database B rds.logical_replication = 1 and restart the Postgres Service.

As a next step, I check from the server side the parameters with this query :

SELECT name,setting 
FROM pg_settings 
WHERE name IN ('wal_level','rds.logical_replication');

But these parameters are still same: rds.logical_replication = off and wal_level=replica. What should be the steps to enable logical replication from AWS Read Replica instance?

Upvotes: 1

Views: 3264

Answers (1)

v-rosa
v-rosa

Reputation: 134

Which engine version are you using? According to the AWS documentation it's only possible from 14.1 onwards.

You can't create a read replica from another read replica if your RDS for PostgreSQL DB instance is running a PostgreSQL version earlier than 14.1. RDS for PostgreSQL supports cascading read replicas on RDS for PostgreSQL version 14.1 and higher releases only. For more information, see Using cascading read replicas with RDS for PostgreSQL.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.Replication.ReadReplicas.html#USER_PostgreSQL.Replication.ReadReplicas.Limitations

Upvotes: 1

Related Questions