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:55:20 -0400
Message-ID: <CANzqJaA+Lw5XkhXKAARydkntyJS5mFnjZEMbKrcYhvdt4yTCYQ@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>

Be like Project Farm, and test that. 😀  For example, insert records with
all sorts of non-ASCII characters (i.e. letters with diacritic marks, œ, æ,
other currency symbols etc) into  "SELECT text_fld FROM very_big_table_
ORDER BY text_fld" into a csv file on each server, and then take the md5sum.

Testing various regex predicates in WHERE clauses is also a good ise.

If they're not the same, well, you have your answer: it's a problem.  If
they _are_ the same, then *either* it's not a problem *or* your test data
is insufficient.

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!

view thread (5+ messages)  latest in thread

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: <CANzqJaA+Lw5XkhXKAARydkntyJS5mFnjZEMbKrcYhvdt4yTCYQ@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