How to Automate PostgreSQL 12 Replication and Failover with repmgr

How to Automate PostgreSQL 12 Replication and Failover with repmgr replication slot is active for pid Slot Status Ackd Memory Ackd Cores > Detected an Active mate Beginning configuration replication from mate replication slot Active Active in Postgres 16 Production Postgres · Active Active in Postgres 16 Postgres 16 is out and it has some exciting updates to logical replication

replication slot To resolve these errors, remove the used replication slots, or increase the value of the max_replication_slots parameter Resolution Remove used replication

replication slot is active for pid When this slot should be active, because you have a secondary site configured using that slot, look for the PostgreSQL logs for the secondary site, to view why active_pid : The PID of the WAL sender process that is using this slot, if active xmin : The oldest transaction ID that this slot needs to retain