Request a Demo
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date
Msg-id CANzqJaBefppMx=O6yHEd3osx+5obhWtt31cV8GXP2Kz+4iuvWA@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)  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-general
Tree view
On Fri, Oct 24, 2025 at 8:59 AM Greg Sabino Mullane <htamfids@gmail.com> wrote:
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.

Not only that, but applying minor version update RPMs is fast.
Last weekend, this took 12 seconds to run:
alias suip='sudo -iupostgres'
suip pg_ctl stop -mfast -wt9999 \
    && sudo yum install -y Pg17.6_RHEL8/*rpm \
    && suip pg_ctl start -wt9999 \
    && psql -Xc "select version()"

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Why is this query touching 4gb of buffers?
Next
From: Adrian Klaver
Date:
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)