Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) - Mailing list pgsql-general

From David Rowley
Subject Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date
Msg-id CAApHDvoSZZ-cVx+rNZ0tihNB9_nmEFp1yF_BM4P0wnwuD=fYCA@mail.gmail.com
Whole thread Raw
In response to Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)  (Devrim Gündüz <devrim@gunduz.org>)
List pgsql-general
On Fri, 24 Oct 2025 at 07:17, Devrim Gündüz <devrim@gunduz.org> wrote:
> This happens because of the glibc version differrence between RHEL X and RHEL Y. At this point you either have to
rebuildall indexes (sorry!) or redo the upgrade via logical replication (if it works for your app's behaviour) 

There was a mention in [1] about a wiki page which includes a query to
identify which indexes could be affected. While that *could* be all
indexes, it does seem unlikely.

David

[1] https://postgr.es/m/CAOg7f80JJCMHXhNLUjnHMwBFV-f9Msv4L=PML0CdaZ4n47uEeA@mail.gmail.com



pgsql-general by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Convert date and time colums to datetime