PostgreSQL Logical Replication Gotchas

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

The PostgreSQL 10 comes with new defaults that allow replication slots, walsenders and replication Does it drop the subscriber table or

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

drop and lock slot machine PostgreSQL will not remove transaction log files for which changes exist that have not been processed by a replication slot For this reason, replication slots