Logical Replication in PostgreSQL

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

When dropping a subscription that is associated with a replication slot on the remote host , DROP SUBSCRIPTION will connect to the remote host

postgresql replication slot Currently postgres doesn't allow dropping a replication slot that's active This can make certain operations more time-consuming or stuck in production

postgres delete replication slot After deleting the unused replication slot, PGSQL happily goes about its business and purgesrotates the old, unnecessary WAL files If you