Streaming replication slots in PostgreSQL - 2ndQuadrant

delete all data on the replica and pull it from the leader): root@my-postgres-0:homepostgres# patronictl reinit my-postgres my-postgres-1

Delete the Replication Slot: Once you've identified the slot, you can delete it using the pg_drop_replication_slot function Replace slot_name with

postgresql drop replication slot A replication slot has an identifier that is unique across all databases in a PostgreSQL cluster Slots persist independently of the connection using them and

postgres delete replication slot SELECT pg_drop_replication_slot; Replace 'slot_name' with the name of the replication slot you want to remove Clean Up: