Re: Logical Replication Delay - Mailing list pgsql-general

From GF
Subject Re: Logical Replication Delay
Date
Msg-id CAFePLY0q=tcuLzYjQdwncQS2ERZrzyFna27hex3vBYwWxFHe_g@mail.gmail.com
Whole thread Raw
In response to Re: Logical Replication Delay  (Ramakrishna m <ram.pgdb@gmail.com>)
List pgsql-general
Hi Ram,

 29 set 2024, 12:29 Ramakrishna m <ram.pgdb@gmail.com>:

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

pgsql-general by date:

Previous
From: Ramakrishna m
Date:
Subject: Re: Logical Replication Delay
Next
From: Koen De Groote
Date:
Subject: Basebackup fails without useful error message