Checking for replication slots - PostgreSQL Replication

The concept of replication slots was introduced in PostgreSQL and was created to prevent a primary instance to delete WAL that a replica

SELECT pg_drop_replication_slot FROM pg_replication_slots WHERE slot_name IN ; The replication slots can

drop slot safes 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

dropz slot A limitation of the PostgreSQL implementation is that replication slots are not cluster-aware: a replication slot exists solely on the instance