public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Replication using patroni on different ubuntu os versions
Date: Tue, 16 Sep 2025 09:56:23 -0400
Message-ID: <CANzqJaBPX-W0FBw+jEzRqkQ6FvK24H2gKRLtDmnB+oAg+XmVCg@mail.gmail.com> (raw)
In-Reply-To: <CAOZWJqOXAfNG-oO7dy7PBkyTzF_jA5-Yr5_oLjbfVyYWFHrMjw@mail.gmail.com>
References: <CAOZWJqOoo6AO-Q+N-ajfAQwRHD2vkF2EqxDO2e576JZKhVydQQ@mail.gmail.com>
	<CANzqJaBAtKOsOxjhUu7eyDCimpzt+dVnV3LRMF2edxF_X5GTFg@mail.gmail.com>
	<CAOZWJqOXAfNG-oO7dy7PBkyTzF_jA5-Yr5_oLjbfVyYWFHrMjw@mail.gmail.com>

The bottom line is that it's not supported.  You're doing this your own
risk.

On Tue, Sep 16, 2025 at 6:36 AM OMPRAKASH SAHU <[email protected]> wrote:

> 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, <[email protected]> wrote:
>
>> On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <[email protected]>
>> 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..
>>
>> --
>> Death to <Redacted>, and butter sauce.
>> Don't boil me, I'm still alive.
>> <Redacted> lobster!
>>
>

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

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]
  Subject: Re: Replication using patroni on different ubuntu os versions
  In-Reply-To: <CANzqJaBPX-W0FBw+jEzRqkQ6FvK24H2gKRLtDmnB+oAg+XmVCg@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