public inbox for [email protected]  

help / color / mirror / Atom feed
From: GF <[email protected]>
To: Ramakrishna m <[email protected]>
Cc: Greg Sabino Mullane <[email protected]>
Cc: Justin <[email protected]>
Cc: pgsql-general <[email protected]>
Cc: [email protected]
Subject: Re: Logical Replication Delay
Date: Sun, 29 Sep 2024 14:26:42 +0200
Message-ID: <CAFePLY0q=tcuLzYjQdwncQS2ERZrzyFna27hex3vBYwWxFHe_g@mail.gmail.com> (raw)
In-Reply-To: <CAG-eXHJNRhnjEbCYHdpcQULxaGqV0_JR4nSPxndRRUdshMNZ0A@mail.gmail.com>
References: <CAG-eXHKr5pFzCKNqVhjQAUM0oxxCe8YUfjoLT8WmZx54Sk48kg@mail.gmail.com>
	<CAKAnmmLmvuo=TORx=hDw2y5fFOUc0sHb88O+6Z-Cs=oVtN9W4A@mail.gmail.com>
	<CAG-eXHJNRhnjEbCYHdpcQULxaGqV0_JR4nSPxndRRUdshMNZ0A@mail.gmail.com>

Hi Ram,

 29 set 2024, 12:29 Ramakrishna m <[email protected]>:

*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


view thread (2+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Logical Replication Delay
  In-Reply-To: <CAFePLY0q=tcuLzYjQdwncQS2ERZrzyFna27hex3vBYwWxFHe_g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox