Preventing WAL Growth on Postgres DB Running on AWS RDS

Replication allows a client to receive a continuous stream of updates from a PostgreSQL database, providing a near-realtime view of all changes as they occur

A logical decoding output plug-in You might need to install the output plug-in that you choose to use You must configure a replication slot that uses your

postgres delete replication slot We need to sync the postgresdata directory The PostgreSQL way is to run pg_basebackup which syncs it over the replication slot Here is a

postgres create logical replication slot A replication slot is a PostgreSQL feature which ensures that a stream of changes stored in a WAL log file is replicated to the destination in the correct order