PostgreSQL: All replication slots are in use

drop replication slot   Dan drops of water slot

The morale of the story? Don't leave your replication slots unattended! There shouldn't be any slots which are inactive for too long For

Normally, the remote replication slot is created automatically when the subscription is created during CREATE SUBSCRIPTION, and it is dropped When dropping a subscription, the replication slot should be kept This could be useful when the subscriber database is being moved to a different host and will

plinko slot As a PostgreSQL administrator, drop the replication slot on the primary database server Do not use the property to drop the replication slot  If set to -1 , you will not be able to delete WAL files due to open logical replication slots that information is not read from