PostgreSQL Replication Slots

website drop replication slot True if this is a temporary replication slot Temporary slots are not saved to disk and are automatically dropped on error or when the session has finished drop slot Examples · Create physical_one physical slot if doesn't exist · postgres · physical_one · Remove physical_one slot if exists · postgres · physical_one · ansible

drop replication slot Does it drop the subscriber table or just stop sending updates? On master there is replication slot for slave and it shows correct  Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be  Deleting a slot that's currently being used by a replica can cause replication issues, leading to potential data loss

Share

Share

Link

Turn off sharing Copy link

See all details