DROP SUBSCRIPTION - pgPedia

Disconnecting Subscribers If communication is functioning, unhook a subscriber is run DROP SUBSCRIPTION , and the corresponding replication slot will be

The WAL files will just pile up So you need to monitor the slots and manually drop them Only when you do that will the master delete anything

drop slot safe SELECT pg_drop_replication_slot; Replace 'slot_name' with the name of the replication slot you want to remove Clean Up:

drop em slot This simply introduces two new options allowing to create or drop a physical replication slot, respectively –create-slot and –drop-slot The