public inbox for [email protected]
help / color / mirror / Atom feedFrom: Joe Conway <[email protected]>
To: Devrim Gündüz <[email protected]>
To: [email protected]
To: Paul Foerster <[email protected]>
Subject: Re: Moving from Linux to Linux?
Date: Tue, 11 Mar 2025 12:36:40 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
On 3/11/25 12:30, Devrim Gündüz wrote:
> Streaming replication won't work between SLES and RHEL, mostly because
> of glibc incompatibilities. Use logical replication.
To be clear, it probably will "work" for some definition of "work" as
long as the architecture is the same. In other words if you try it, it
might well appear to work ok.
However as Devrim correctly points out, differences in glibc versions
almost certainly will mean that you will have corrupt indexes on
collatable columns. These indexes can be fixed via REINDEX, but if you
don't do that *before* allowing any DML you risk further complications
such as inability to REINDEX due to duplicate primary key values.
HTH,
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
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], [email protected], [email protected], [email protected]
Subject: Re: Moving from Linux to Linux?
In-Reply-To: <[email protected]>
* 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