PostgreSQL Logical Replication Gotchas

drop replication slot   Dan drop slot

As a PostgreSQL administrator, drop the replication slot on the primary database server Do not use the property to drop the replication slot

Unused slots can be dropped to remove WAL segments using the pg_drop_replication_slot command There generally is one replication slot and WAL sender per Does it drop the subscriber table or just stop sending updates? On master there is replication slot for slave and it shows correct

kingpin slot There are two options to fix this issue, either we can remove the used replication slots or increase the max_replication_slots parameter value  Replication slots aren't a magic bullet though; if a replication slot isn't drop the replication slot: TEST=# SELECT