Postgres Logical Replication and Idle Databases

Postgres Logical Replication and Idle Databases postgres delete replication slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be postgres create replication slot 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

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

postgres replication slot 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 A set of WAL records are reserved on the primary database when a replication slot is created The modifications made to the