Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Devrim Gündüz <devrim(at)gunduz(dot)org>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org, Bala M <krishna(dot)pgdba(at)gmail(dot)com>
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date: 2025-10-23 19:37:17
Message-ID: CAApHDvoSZZ-cVx+rNZ0tihNB9_nmEFp1yF_BM4P0wnwuD=fYCA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 24 Oct 2025 at 07:17, Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:
> This happens because of the glibc version differrence between RHEL X and RHEL Y. At this point you either have to rebuild all 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2025-10-23 19:52:29 Re: Convert date and time colums to datetime
Previous Message Devrim Gündüz 2025-10-23 18:16:59 Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)