Re: Moving from Linux to Linux?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Devrim Gündüz <devrim(at)gunduz(dot)org>, pgsql-general(at)lists(dot)postgresql(dot)org, Paul Foerster <paul(dot)foerster(at)gmail(dot)com>
Subject: Re: Moving from Linux to Linux?
Date: 2025-03-11 16:36:40
Message-ID: 1396c795-49b5-4892-a7d3-da8456ada1ed@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Foerster 2025-03-11 18:34:21 Re: Moving from Linux to Linux?
Previous Message Ron Johnson 2025-03-11 16:32:39 Re: Moving from Linux to Linux?