replication slot postgres: How Patroni Addresses the Problem of the Logical Replication Slot Failover in a PostgreSQL Cluster. Out of the Box Replication in Postgres 9.4(PgCon) | PDF. NGƯỜI SỬ DỤNG - 1 slot.
Failover of the logical replication
slot has always been the pain point while using the logical replication in PostgreSQL... until Patroni 2.1.0.
This setting, new in Postgres 17, makes sure that any logical replication
slots we are going to set up in the following cannot advance beyond the confirmed log sequence number (LSN) of this physical slot.