Enable logical replication on Amazon RDS PostgreSQL®#

If you have not enabled logical replication on RDS already, the following instructions shows how to set the rds.logical_replication parameter to 1 (true) in the parameter group.

  1. Create a parameter group for your RDS database.

    RDS PostgreSQL parameter group

  2. Set the rds.logical_replication parameter to 1 (true) in the parameter group

    RDS PostgreSQL parameter value

  3. Modify Database options to use the new DB parameter group - RDS -> Databases -> Modify

    RDS PostgreSQL parameter modify

Warning

Apply immediately or reboot is required to see configuration change reflected to wal_level