How CloudNativePG manages physical replication slots for

website postgresql drop replication slot Learn how to use replication slots with PostgreSQL's streaming physical replication drop a slot psql -c select * from pg_drop_replication_slot('replica postgresql drop replication slot Drop the replication slot with the name specified by --slot , then exit In --drop-slot mode, delete the slot with this name -t --two-phase Enables

postgresql drop replication slot Drop the replication slot created on the incorrect database An unused slot will continue to hold on to the Write Ahead Log forever which can cause server bloat  You can list all available replication slots and their details using the pg_replication_slots view SELECT * FROM pg_replication_slots;  Physical slots are created automatically based on replica hosts and used for data replication within the Managed Service for PostgreSQL cluster

Share

Share

Link

Turn off sharing Copy link

See all details