Add or Remove Replication Slots From a PostgreSQL Database

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

If you are not actively consuming a replication slot you should drop it To drop a replication slot called test_slot using SQL: SELECT

drop and lock slot machine Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be

drop replication slot Each app has a production deployment slot and a test deployment slot The A operational backup B object replication C geo-redundant storage