Re: Replication using patroni on different ubuntu os versions

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