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

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

Hi @Ron,

What if collation is glibc independent i.e inbuilt C.UTF-8? still do we
have any chance of inconsistency?

Regards,
OM

On Tue, 16 Sept 2025, 13:05 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:

> On Tue, Sep 16, 2025 at 3:18=E2=80=AFAM OMPRAKASH SAHU <sahuop2121@gmail.=
com>
> 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 collatio=
n
> changes from gnu libc version upgrades..
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"auto"><div>Hi @Ron,</div><div dir=3D"auto"><br></div><div dir=
=3D"auto">What if collation is glibc independent i.e inbuilt C.UTF-8? still=
 do we have any chance of inconsistency?</div><div dir=3D"auto"><br></div><=
div dir=3D"auto">Regards,</div><div dir=3D"auto">OM=C2=A0<br><br><div class=
=3D"gmail_quote gmail_quote_container" dir=3D"auto"><div dir=3D"ltr" class=
=3D"gmail_attr">On Tue, 16 Sept 2025, 13:05 Ron Johnson, &lt;<a href=3D"mai=
lto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:=
1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Tue, =
Sep 16, 2025 at 3:18=E2=80=AFAM OMPRAKASH SAHU &lt;<a href=3D"mailto:sahuop=
2121@gmail.com" target=3D"_blank" rel=3D"noreferrer">sahuop2121@gmail.com</=
a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><div dir=3D"auto">Hi Team,<div dir=3D"auto"><br></div>=
<div dir=3D"auto">Greetings!!</div><div dir=3D"auto"><br></div><div dir=3D"=
auto">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 D=
R region.</div><div dir=3D"auto"><br></div><div dir=3D"auto">So if we do th=
e switch over on DR and then switch back to primary region, is there any ch=
ance of data corruption due to OS version mismatch.</div></div></blockquote=
><div><br></div><div>The problem is that corruption in text indices can hap=
pen due to collation changes from gnu libc version upgrades..</div></div><d=
iv><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&g=
t;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><=
div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>
</blockquote></div></div></div>

--000000000000d27d6b063ee8b134--