Amazon RDS

In this page, we'll go over how to enable write-ahead log (WAL) for your AWS RDS instance running PostgreSQL.

Turning on logical replication

Go into the RDS dashboard and click create a parameter group.

Make sure you select the right DB family group. Use postgres10 if your database is running on 10.X.

Find the rds.logical_replication parameter and set it to 1.

Now, go to your database, modify the instance to attach the newly created parameter group and then restart your database.

Note rds.logical_replicationis a static parameter, which requires DB reboot to have effect.