Request a Demo
Home   >   mailing lists

Re: Replication using patroni on different ubuntu os versions - Mailing list pgsql-admin

From OMPRAKASH SAHU
Subject Re: Replication using patroni on different ubuntu os versions
Date
Msg-id CAOZWJqOXAfNG-oO7dy7PBkyTzF_jA5-Yr5_oLjbfVyYWFHrMjw@mail.gmail.com
Whole thread Raw
In response to Re: Replication using patroni on different ubuntu os versions  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Replication using patroni on different ubuntu os versions
Re: Replication using patroni on different ubuntu os versions
List pgsql-admin
Tree view
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 AM 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 collation changes from gnu libc version upgrades..

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

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Replication using patroni on different ubuntu os versions
Next
From: Ron Johnson
Date:
Subject: Re: Replication using patroni on different ubuntu os versions