Skip to content

RDS Replication Management

RDS provides an rds_replication role that is required for doing replication on RDS in postgres. This role does NOT have the REPLICATION priviledge required to muck with the WAL readers. So there must be some internal to RDS implementation that allows the replciation management. For instance, if you log into a postgres instance with a user with the rds_replication role you cannnot execute the pg_replication_slot_advance stored procedure to move the lsn for the slot around.

The master user provided by RDS does not even have this role or SUPERUSER to grant this role. They have rds_superuser which does not have the ability to grant REPLICATION.