PostgreSQL Replication Slots

PostgreSQL Replication Slots postgres drop replication slot Drop the replication slot with the name specified in --slot , then exit Other options are also available: -V --version Print the postgresql replication slot postgresql_slot module

postgresql replication slot Currently postgres doesn't allow dropping a replication slot that's active This can make certain operations more time-consuming or stuck in production

postgres replication slot The replication slot basically tells Postgres not to recycle or remove any WAL files that could ultimately prevent it from catching up with When dropping a subscription, the replication slot should be kept This In that case, disassociate the slot from the subscription using ALTER SUBSCRIPTION