Monitoring PostgreSQL Replication Slots and Sending Email Alerts

Monitoring PostgreSQL Replication Slots and Sending Email Alerts replication slot postgres postgresql_slot module replication slot When dropping a subscription, the replication slot should be kept This could be useful when the subscriber database is being moved to a different host and will

replication slot A replication slot is created on the primary database server for each standby server The slot keeps track of the last confirmed receive location of WAL data on

replication slot postgres Checking for replication slots Starting from PostgreSQL , it is also necessary and useful to check for leftover replication slots  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