Re: Replication using patroni on different ubuntu os versions

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Replication using patroni on different ubuntu os versions
Date: 2025-09-16 13:56:23
Message-ID: CANzqJaBPX-W0FBw+jEzRqkQ6FvK24H2gKRLtDmnB+oAg+XmVCg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <sahuop2121(at)gmail(dot)com> 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, <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>> On Tue, Sep 16, 2025 at 3:18 AM OMPRAKASH SAHU <sahuop2121(at)gmail(dot)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
>> 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!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Stearns 2025-09-16 20:13:58 dropuser error
Previous Message Ron Johnson 2025-09-16 13:55:20 Re: Replication using patroni on different ubuntu os versions