MIME-Version: 1.0
References: <CAG-eXHKr5pFzCKNqVhjQAUM0oxxCe8YUfjoLT8WmZx54Sk48kg@mail.gmail.com>
 <CAKAnmmLmvuo=TORx=hDw2y5fFOUc0sHb88O+6Z-Cs=oVtN9W4A@mail.gmail.com> <CAG-eXHJNRhnjEbCYHdpcQULxaGqV0_JR4nSPxndRRUdshMNZ0A@mail.gmail.com>
In-Reply-To: <CAG-eXHJNRhnjEbCYHdpcQULxaGqV0_JR4nSPxndRRUdshMNZ0A@mail.gmail.com>
From: GF <phabriz@gmail.com>
Date: Sun, 29 Sep 2024 14:26:42 +0200
Message-ID: <CAFePLY0q=tcuLzYjQdwncQS2ERZrzyFna27hex3vBYwWxFHe_g@mail.gmail.com>
Subject: Re: Logical Replication Delay
To: Ramakrishna m <ram.pgdb@gmail.com>
Cc: Greg Sabino Mullane <htamfids@gmail.com>, Justin <zzzzz.graf@gmail.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>, ravisql09@gmail.com
Content-Type: multipart/alternative; boundary="00000000000023842d0623413467"
Archived-At: <https://www.postgresql.org/message-id/CAFePLY0q%3DtcuLzYjQdwncQS2ERZrzyFna27hex3vBYwWxFHe_g%40mail.gmail.com>
Precedence: bulk

--00000000000023842d0623413467
Content-Type: text/plain; charset="UTF-8"

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

--00000000000023842d0623413467
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div>Hi Ram,<br><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">=C2=A029 set 2024, 12:29 Ramakrishna m &lt;<a=
 href=3D"mailto:ram.pgdb@gmail.com">ram.pgdb@gmail.com</a>&gt;:</div><div d=
ir=3D"ltr" class=3D"gmail_attr"><br></div><blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><d=
iv dir=3D"ltr"><div dir=3D"ltr"><div><font face=3D"arial, sans-serif" color=
=3D"#000000" style=3D"background-color:rgb(255,255,255)"><b>We are planning=
 to set up logical replication from a standby to another server. When the p=
rimary 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?=C2=A0</b></font></div><=
/div></div></blockquote></div></div><div dir=3D"auto"><br></div><div dir=3D=
"auto">You could take a look at the pg_failover_slots extension (<a href=3D=
"https://www.enterprisedb.com/docs/pg_extensions/pg_failover_slots/">https:=
//www.enterprisedb.com/docs/pg_extensions/pg_failover_slots/</a>), it is ai=
med exactly at cloning the slot information to a standby.</div><div dir=3D"=
auto"><br></div><div dir=3D"auto">Best,</div><div dir=3D"auto">giovanni</di=
v><div dir=3D"auto"><br></div><div dir=3D"auto"><div class=3D"gmail_quote">=
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
</blockquote></div></div></div>

--00000000000023842d0623413467--