The Insatiable Postgres Replication Slot

Checking for replication slots - PostgreSQL Replication postgres drop replication slot By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL postgres delete replication slot Now a common cause for this kind of issue are replication slots which are not advanced: in that case, Postgres will hold on to all WAL segments

postgres create replication slot When dropping a subscription, the replication slot should be kept This In that case, disassociate the slot from the subscription using ALTER SUBSCRIPTION