Implementing failover of logical replication slots in Patroni

AWS RDS PostgreSQL has logical replication enabled from + onwards Generally in a logical replication once the subscriber is enabled,

Allow you to replicate data out of Postgres · Use the write-ahead log as the source of changes · Use logical replication slots to send out

create replication slot postgres Replication slots were introduced in Postgres They are a mechanism to accurately and durably keep track of how far a standby is lagging behind the primary

create replication slot The logical solution is to make the primary to keep track of how far behind the standby is, and to not delete WAL files that any standbys still