Add or remove replication slots from a PostgreSQL database

website drop replication slot replication slot mysub on publisher CREATE SUBSCRIPTION The -- pause replication ALTER SUBSCRIPTION mysub DISABLE; -- drop and lock slot machine Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be

drop replication slot Replication slots will prevent removal of required resources even when there is no connection using them This consumes storage because neither  Replication slots were introduced in PostgreSQL to help ensure a primary PostgreSQL instance does not remove WAL files before a replica has  pg_drop_replication_slot() is a system function for removing a physical or logical replication slot pg_drop_replication_slot() was added in PostgreSQL

Share

Share

Link

Turn off sharing Copy link

See all details