Checking for replication slots - PostgreSQL Replication

The logical solution is to make the primary to keep track of how far behind the standby is, and to not delete WAL files that any standbys still

Check if there is any replication lag, and when it reaches zero, run DROP SUBSCRIPTION on the subscriber This will drop the replication slot on

postgres create logical replication slot If stopping postgres server takes time, the VM or container will have to be killed forcefully which can take a considerable amount of time as

postgres delete replication slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be