Re: Moving from Linux to Linux?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Paul Foerster <paul(dot)foerster(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Pgsql-General List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Moving from Linux to Linux?
Date: 2025-03-13 02:55:11
Message-ID: c60b0558-290b-4fe8-b839-6a7725c980b3@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/12/25 16:55, Paul Foerster wrote:
> Hi Adrian,
>
>> On 12 Mar 2025, at 21:26, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>>
>> A good summary of the glibc issue:
>>
>> https://wiki.postgresql.org/wiki/Locale_data_changes
>>
>> With distro information:
>>
>> https://wiki.postgresql.org/wiki/Locale_data_changes#What_Linux_distributions_are_affected
>
> I know the article, thanks. We needed a full reindex when upgrading from SLES 15.2 to 15.3. We're on 15.5 now, partly already on 15.6. Thank god, we didn't have that ugly database back then that we have now. But I see the next doomsday coming on the horizon. 🤣
>
> Also, we try to get rid of the libc locale provider and switch to libicu, wherever possible.

If you are desperate you could start with
https://github.com/awslabs/compat-collation-for-glibc and create a new
branch for your current version of SLES/glibc and deploy the resulting
rpm to RHEL. At least in theory. FWIW I was able to get the glibc locale
compatibility library for AL2 (glibc 2.26) to work fine on Linux Mint
system (glibc 2.34).

For more on the compatibility library you could watch a presentation[1]
starting here:
https://youtu.be/0E6O-V8Jato?t=1749

The other option, which may be equally untenable, is to upgrade in-place
to pg17 and convert everything to use the new built-in collation
provider. That ought to be portable across different versions of Linux.

The problem you might find with libicu is that different versions of ICU
can have the same issues as different versions of glibc, and you might
not have the same ICU version available on SLES and RHEL.

If you want to explore the compatibility library approach contact me off
list and I will try to get you started. It has been a couple of years
since I touched it, but when I did it took me a couple of days to get
from the AL2 (glibc 2.26) branch (which was done first) to the RHEL 7
(glibc 2.17) branch.

HTH,

[1] https://www.joeconway.com/presentations/2025-PGConf.IN-glibc.pdf

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Foerster 2025-03-13 08:53:16 Re: Moving from Linux to Linux?
Previous Message Adrian Klaver 2025-03-12 21:37:33 Re: Moving from Linux to Linux?