How Do I Remove Streaming Replication wo Failover? : rPostgreSQL

Streaming replication slots in PostgreSQL - 2ndQuadrant postgres delete 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 postgres create logical replication slot Use pg_drop_replication_slot : select pg_drop_replication_slot; See the docs and this blog The replication slot must be

postgresql replication slot catalog_xmin, xid, The oldest transaction affecting the system catalogs that this slot needs the database to retain VACUUM cannot remove catalog tuples deleted