Inside logical replication in PostgreSQL: How it works

website postgres drop replication slot If a logical replication slot is no longer used, drop it immediately The 'active' column in the pg_replication_slots view will indicate whether postgres create logical replication slot Replication slots provide an automated way to ensure that the primary does not remove WAL segments until they have been received by all standbys

postgres drop replication slot psql dbname=postgres replication=database -c IDENTIFY_SYSTEM; Drops a replication slot, freeing any reserved server-side resources If the  A logical decoding output plug-in You might need to install the output plug-in that you choose to use You must configure a replication slot that uses your  SELECT pg_drop_replication_slot; Replace 'slot_name' with the name of the replication slot you want to remove Clean Up:

Share

Share

Link

Turn off sharing Copy link

See all details