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 03:34:40 -0400
Message-ID: <CANzqJaBAtKOsOxjhUu7eyDCimpzt+dVnV3LRMF2edxF_X5GTFg@mail.gmail.com> (raw)
In-Reply-To: <CAOZWJqOoo6AO-Q+N-ajfAQwRHD2vkF2EqxDO2e576JZKhVydQQ@mail.gmail.com>
References: <CAOZWJqOoo6AO-Q+N-ajfAQwRHD2vkF2EqxDO2e576JZKhVydQQ@mail.gmail.com>

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!


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: <CANzqJaBAtKOsOxjhUu7eyDCimpzt+dVnV3LRMF2edxF_X5GTFg@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