pg replication slots - Best practices for Amazon RDS PostgreSQL replication | AWS Database ... bm888 slot

Monitor replication slots: If you enable the previous parameter, unconsumed WAL files keep accumulating at the source. As a best practice, keep a close eye on replication slots and kill inactive ones.

We will demonstrate How to Setup Streaming Replication with pgBackRest in PostgreSQL. Setup a shared repository (NFS) between the hosts, Prepare the Primary Node for Replication, Update pg_hba.conf, Configure pgBackRest to backup the Primary Node, Standby Setup, Test Streaming Replication.

47.2. Logical Decoding Concepts # 47.2.1. Logical Decoding 47.2.2. Replication Slots 47.2.3. Replication Slot Synchronization 47.2.4. Output Plugins 47.2.5.