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 1uyW9i-0097vw-Nc for pgsql-admin@arkaria.postgresql.org; Tue, 16 Sep 2025 13:55:38 +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 1uyW9e-000Zi8-7x for pgsql-admin@arkaria.postgresql.org; Tue, 16 Sep 2025 13:55:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uyW9d-000Zi0-NM for pgsql-admin@lists.postgresql.org; Tue, 16 Sep 2025 13:55:34 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uyW9c-000jg0-05 for pgsql-admin@postgresql.org; Tue, 16 Sep 2025 13:55:33 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-330d1565844so2806237fac.1 for ; Tue, 16 Sep 2025 06:55:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758030931; x=1758635731; 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=Z2ZDoINe7tq2hBCEJlqItI6tY3Mvp7OJw5KRcjO9ezI=; b=Uwr6srgDu+mC/HERRD1XOKs93ulmrX68YHaUS4Oc6MRyKCwW3CSxqkXaYxD4TLin3T EFxZ4/xwvsh2+oXuqFn/QWbHgG3o3jwcFQZL9yH3DMpu/I2M9t4qw2Mb03qZcv8t8aDE iUIbi0ylaZ/tBKh0hqtn0ID/kSs6ta6OfsCw4Xy6+znfx2xWUSRFF2T18swsCr4D5+LE /IyywRxxZaLTRZcolp5uuemDWL34365zUaLyjfq9yIEldUXOieJOhRoeebdYjt+GGTjK +neZj3S1bEHk/S5L1IACNKR80ukHfbFPQaLfOL4A8SANnjzNcWint6YpaHAyQwdCga3p oGlQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758030931; x=1758635731; 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=Z2ZDoINe7tq2hBCEJlqItI6tY3Mvp7OJw5KRcjO9ezI=; b=NOo4VxpfcMwqcqsIn8sx//Hq4rT2kgSws103ifKAI+4LBeJMKXd3qR4FDVBU/zCpGb eInQFs/oU/DRD+g6s/Xl8FDmRyaqUca4iBSsLqZBU6dpQXrqfpz7cYmYxd9As3VlzxSS wMfZDTzP0nmoNo+C2j0CDc4QcK1ZPDIymFGjO4tfGUeiChoWmexAhkfZDb1UkGPMmMSz cE1OHt8DTC652vcj9rIcPpu7/zlH6IFPJLbRBpz6XLsWjTzwwJ1R3THPnq3o3qsVLzGr gORgXLcZ9Jqnw/CVu8yt+rXVTpDeR24j6w15F3JOFmEtuApsYHzpPwDyyTI0SHXVQv/2 oXLw== X-Gm-Message-State: AOJu0YyDqmTAxoK9CE/sKX8DvZQeDMPJHmmzk8oTICmOUhqy+baVE3Dc ma1cN1kmmLlolic9IiMy9F4FgqjWqf3psVzRnxjbpKnmMJKZF+zgJ17axYh9UIf7HNKshdAdq1/ sjmHQVMwMjMAPfXRxTrxNbZueEar1eeWx6dJa X-Gm-Gg: ASbGncu5j//vXXZ4oEvySLXrCTLUVeS6gPhGS1XyCVWQ099BW4lZrI66HWlBvFhOeq9 puvVqtQKMt5dMfw4wDFbrzpes9DIolzWgeIaX3jza5UWl1GDc6eAwkRkDu0tiZXpgqGJ347REvQ s6L9WlZdR1dhyjBKrOHoxZEvT9ToyqwufZpUk+10J4WcaTYxNbWLY0IUTHdJYuqRoXSclBNseGF CyV8NSXzVE7KPM49kk= X-Google-Smtp-Source: AGHT+IHu3LgoZVkkOrv36yUUkm7YwigB4NyUiOZ4DKQKiY3KYCAG+CNfsL0H5zFwpvuvzzrlejcdi1rWhrdB/5lkJds= X-Received: by 2002:a05:6870:a9a6:b0:31d:7326:c3b1 with SMTP id 586e51a60fabf-32e58f92262mr7491495fac.46.1758030931167; Tue, 16 Sep 2025 06:55:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Tue, 16 Sep 2025 09:55:20 -0400 X-Gm-Features: AS18NWCCba9HeK8ZWwBeag7O5khnMESiuYSDNqnXjixy-FA3D8eHUsPTNi7bowY Message-ID: Subject: Re: Replication using patroni on different ubuntu os versions To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000280f4c063eeb7923" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000280f4c063eeb7923 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Be like Project Farm, and test that. =F0=9F=98=80 For example, insert reco= rds with all sorts of non-ASCII characters (i.e. letters with diacritic marks, =C5= =93, =C3=A6, 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=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.. >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000280f4c063eeb7923 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Be like Project Farm, and test that.=C2=A0=F0=9F=98= =80 =C2=A0For example, insert records with all sorts of non-ASCII character= s (i.e. letters with diacritic marks,=C2=A0=C5=93,=C2=A0=C3=A6, other curre= ncy symbols=C2=A0etc) into=C2=A0 "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.=C2=A0 If they _are_ = the same, then *either* it's not a problem *or* your test data is insuf= ficient.

On Tue, Sep 16, 2025 at 6:36= =E2=80=AFAM OMPRAKASH SAHU <sahu= op2121@gmail.com> wrote:

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