MIME-Version: 1.0
References: 
 <CAOZWJqOoo6AO-Q+N-ajfAQwRHD2vkF2EqxDO2e576JZKhVydQQ@mail.gmail.com>
In-Reply-To: 
 <CAOZWJqOoo6AO-Q+N-ajfAQwRHD2vkF2EqxDO2e576JZKhVydQQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 16 Sep 2025 03:34:40 -0400
Message-ID: 
 <CANzqJaBAtKOsOxjhUu7eyDCimpzt+dVnV3LRMF2edxF_X5GTFg@mail.gmail.com>
Subject: Re: Replication using patroni on different ubuntu os versions
To: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d5f1c4063ee627f5"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaBAtKOsOxjhUu7eyDCimpzt%2BdVnV3LRMF2edxF_X5GTFg%40mail.gmail.com>
Precedence: bulk

--000000000000d5f1c4063ee627f5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Sep 16, 2025 at 3:18=E2=80=AFAM OMPRAKASH SAHU <sahuop2121@gmail.co=
m> wrote:

> Hi Team,
>
> Greetings!!
>
> I have 3 node patroni postgresql cluster in which primary and replica is
> running on Ubuntu 20 and third one is running on Ubuntu 24 that is in DR
> region.
>
> So if we do the switch over on DR and then switch back to primary region,
> is there any chance of data corruption due to OS version mismatch.
>

The problem is that corruption in text indices can happen due to collation
changes from gnu libc version upgrades..

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Sep 16, 2025 at 3:18=E2=80=AFAM O=
MPRAKASH SAHU &lt;<a href=3D"mailto:sahuop2121@gmail.com">sahuop2121@gmail.=
com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><b=
lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi Team,<=
div dir=3D"auto"><br></div><div dir=3D"auto">Greetings!!</div><div dir=3D"a=
uto"><br></div><div dir=3D"auto">I have 3 node patroni postgresql cluster i=
n which primary and replica is running on Ubuntu 20 and third one is runnin=
g on Ubuntu 24 that is in DR region.</div><div dir=3D"auto"><br></div><div =
dir=3D"auto">So if we do the switch over on DR and then switch back to prim=
ary region, is there any chance of data corruption due to OS version mismat=
ch.</div></div></blockquote><div><br></div><div>The problem is that corrupt=
ion in text indices can happen due to collation changes from gnu libc versi=
on upgrades..</div></div><div><br></div><span class=3D"gmail_signature_pref=
ix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"lt=
r">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I=
9;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></=
div></div></div>

--000000000000d5f1c4063ee627f5--