Implementing failover of logical replication slots in Patroni

A logical replication slot knows nothing about the state of the receiver Easy Steps to Set up PostgreSQL Logical Replication One of the

It creates a permanent logical replication slot on the publisher PostgreSQL persists the state of the replication slot information

postgres delete replication slot In --start mode, use the existing logical replication slot named slot_name In --create-slot mode, create the slot with this name In --drop-slot mode, delete

postgresql replication slot To enable this feature, you need to call the pg_create_logical_replication_slot() function or use the CREATE REPLICATION SLOTLOGICAL command