Hi Ram,
29 set 2024, 12:29 Ramakrishna m <ram.pgdb@xxxxxxxxx>:
We are planning to set up logical replication from a standby to another server. When the primary goes down, there is no issue as the standby becomes the primary and the logical slots are already present. However, when the standby goes down, these slots are not copied to the third node or the primary by Patroni. Is there an option available to handle this scenario?
You could take a look at the pg_failover_slots extension (https://www.enterprisedb.com/docs/pg_extensions/pg_failover_slots/), it is aimed exactly at cloning the slot information to a standby.
Best,
giovanni
