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!
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 |