Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uyWAi-00989r-GK for pgsql-admin@arkaria.postgresql.org; Tue, 16 Sep 2025 13:56:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uyWAg-000d8m-Bd for pgsql-admin@arkaria.postgresql.org; Tue, 16 Sep 2025 13:56:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uyWAg-000d8e-08 for pgsql-admin@lists.postgresql.org; Tue, 16 Sep 2025 13:56:38 +0000 Received: from mail-oa1-x29.google.com ([2001:4860:4864:20::29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uyWAd-0018gZ-0c for pgsql-admin@postgresql.org; Tue, 16 Sep 2025 13:56:38 +0000 Received: by mail-oa1-x29.google.com with SMTP id 586e51a60fabf-30cce892b7dso2863127fac.1 for ; Tue, 16 Sep 2025 06:56:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758030995; x=1758635795; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=Gv0mAbFE0oDGff2AVWX85EwTZuPQ9A3hFY7cLc1BS7U=; b=DP83zb/OFB25caL4oIn1mITCm5dFUU46gfzhnLhtCo1oyrcZpEjgdCuMjuWAJzXU6L LxczByVeqO04TBLpIq5QnMaaaGxgfmJmhMAWzU/flkAEfCs3akOIKwyUuHt/lxISP9h5 NQiiEPgKp5DxV/WZeNU7eyhIlXAHFagHnjmZzKf48oCd1ljT6Ltrx7AV2eHXW2dEKHAs RZOwc/9QlJX5ItVyRNkRfOh4p58FZ0qC+6IJOjY4tWGqxFme9liA30JafpLsLoc01qGS MxUGI/SsmxGTrsFeQjsDbMyyU8vDGBlBpwjS9ndpqJAcbehNHlqu5qBO0YoUlSlFOowh Ri0w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758030995; x=1758635795; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Gv0mAbFE0oDGff2AVWX85EwTZuPQ9A3hFY7cLc1BS7U=; b=JTUJzt98dU/fwMlcEud+uCQ2C9tKSNdpNB1sG235Qv/rNRPSk0/vv7RAhs3Fx6OzvY B8JtdEgn4ynHtq3AFp05xb6BQXklRvix2neuud1aObc1d+apAZMJZt2DZuchs0kJknye /y/iYxtZC+HyuEQqWe6j7eg5d3A8TlwoPgVSqxcoRiW3V2TSO9Kp2LoEYb/l6+Xj0myB /iBLPpStFRe+VjXYqHeIhmPLYHi8wEhYjWkmDhOy+XHiMzuj1Rr07buFv8BBOeaR5Dj4 faovEm48VcF27RoRiVzInYwINkMqXqIXu+ujYCUrMOd8wdEAl4Mq+/vjoXzxnLZtopu7 1Rag== X-Gm-Message-State: AOJu0YyI2O2V/OG40lvKOMSCokWJ/OgAkSw54mzM8We+AEP5Sfx0NhH8 Q8z5DgfEORNhJPjp8mxfzkETymDFDN/D363BB433k3zN/mC8lzpAPM3KVM6XvLM3OLlYE0zjD4Z rIlv6eCTrUgoexiX5fjlY5VgTQFgC+vvhDw== X-Gm-Gg: ASbGncsF9sFMEH8XL5WBYKw0HQFyDt9HE6XPboj86OTly7LVaaSBYFkEHp5B2FkJKRj 1lLPI7UOMaOJJ0RWAWTd0dnlUfgPfDgXbV1GTHuY3QqTV/WIVGn5JvPot5jrxllDF+3dMZpTnTN 7LqbDy9GF7psni/edYAQZq8sBpwYqtoxHgbTqt4q1kxxdebKdaz4O9k+aJLDaQvrueabwmO/pij S3B9Dny X-Google-Smtp-Source: AGHT+IHFuaIABZP2grjewdJAn9wzqdiaNogKVnDOzcJFOtTWPRqT19f40KuTe5WUemY9l7TmWcROcjyN13VksZtylnA= X-Received: by 2002:a05:6870:8182:b0:31d:6aa4:eeab with SMTP id 586e51a60fabf-32e53e605d7mr9565026fac.4.1758030994708; Tue, 16 Sep 2025 06:56:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Tue, 16 Sep 2025 09:56:23 -0400 X-Gm-Features: AS18NWCHdGXufhi3STkEY92qcFemgnvo3ko8UQpfwxnp6Z-pYBz1v_9pPboeCVI Message-ID: Subject: Re: Replication using patroni on different ubuntu os versions To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000f19dfb063eeb7c7d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f19dfb063eeb7c7d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable The bottom line is that it's not supported. You're doing this your own risk. On Tue, Sep 16, 2025 at 6:36=E2=80=AFAM OMPRAKASH SAHU 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, wrote: > >> On Tue, Sep 16, 2025 at 3:18=E2=80=AFAM OMPRAKASH SAHU >> wrote: >> >>> Hi Team, >>> >>> Greetings!! >>> >>> I have 3 node patroni postgresql cluster in which primary and replica i= s >>> running on Ubuntu 20 and third one is running on Ubuntu 24 that is in D= R >>> 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 mismat= ch. >>> >> >> The problem is that corruption in text indices can happen due to >> collation changes from gnu libc version upgrades.. >> >> -- >> Death to , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000f19dfb063eeb7c7d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

The bottom line is that it= 's not supported.=C2=A0 You're doing this your own risk.

<= div class=3D"gmail_quote gmail_quote_container">
On Tue, Sep 16, 2025 at 6:36=E2=80=AFAM OMPRAKASH SAHU <sahuop2121@gmail.com> wrote:
<= /div>
Hi @Ron,

What if coll= ation is glibc independent i.e inbuilt C.UTF-8? still do we have any chance= of inconsistency?

Regar= ds,
OM=C2=A0

On Tue, 16 Sept 2025, 13:05= Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Tue, Sep 16= , 2025 at 3:18=E2=80=AFAM OMPRAKASH SAHU <sahuop2121@gmail.com>= wrote:
Hi Team,

Greetings!!

= I have 3 node patroni postgresql cluster in which primary and replica is ru= nning on Ubuntu 20 and third one is running on Ubuntu 24 that is in DR regi= on.

So if we do the swit= ch over on DR and then switch back to primary region, is there any chance o= f data corruption due to OS version mismatch.
=
The problem is that corruption in text indices can happen du= e 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> lobs= ter!
--000000000000f19dfb063eeb7c7d--