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

From Greg Sabino Mullane
Subject Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date
Msg-id CAKAnmm+DcNS_FTGOG9Q3WUQGxxukhqf1rz5jrqzAk0z9W5d59A@mail.gmail.com
Whole thread Raw
In response to Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)  (Bala M <krishna.pgdba@gmail.com>)
Responses Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
List pgsql-general
On Thu, Oct 23, 2025 at 10:51 AM Bala M <krishna.pgdba@gmail.com> wrote:
Any advice, recommendations, or shared experiences from others who have performed similar migrations would be greatly appreciated.

Some related advice: put some system in place to make sure you are always running the latest revision in whatever major version you end up. See:


In particular, note this part:

The community considers performing minor upgrades to be less risky than continuing to run an old minor version.

You also want to put something in place to make sure your major version does not  fall so far behind again. You don't need to upgrade every year, but certainly target a major upgrade every 2-3 years. As you will discover, the major upgrade process is going to be much easier than this current upgrade we are talking about in this thread.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Why is this query touching 4gb of buffers?
Next
From: Tom Lane
Date:
Subject: Re: Why is this query touching 4gb of buffers?