Implementing failover of logical replication slots in Patroni

Postgres logical replication concepts postgres create replication slot By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL postgres drop replication slot A simple case of spill is explained below In the logical replication setup of PostgreSQL 14, prepare one table named tab with an integer column

postgres delete replication slot How it works When a logical replication slot is created, Postgres creates a snapshot of the current state of the database and records the consistent point