public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date: Fri, 24 Oct 2025 09:20:21 -0400
Message-ID: <CANzqJaBefppMx=O6yHEd3osx+5obhWtt31cV8GXP2Kz+4iuvWA@mail.gmail.com> (raw)
In-Reply-To: <CAKAnmm+DcNS_FTGOG9Q3WUQGxxukhqf1rz5jrqzAk0z9W5d59A@mail.gmail.com>
References: <CAJ4rSwspyYBppQS701C=BVFX2yrP1JErgDCZXbC15BQh2zAS1Q@mail.gmail.com>
<CAKAnmmK47O_rYDB4iPe=K3QiqzJcCnnxCoYs_40Q1YWb=x0nDg@mail.gmail.com>
<CAJ4rSwvsRJhwfuem0vsws1WwRZPN8Ju2Nw0e0Oc2j7n=MXUhMg@mail.gmail.com>
<CAKAnmm+DcNS_FTGOG9Q3WUQGxxukhqf1rz5jrqzAk0z9W5d59A@mail.gmail.com>
On Fri, Oct 24, 2025 at 8:59 AM Greg Sabino Mullane <[email protected]>
wrote:
> On Thu, Oct 23, 2025 at 10:51 AM Bala M <[email protected]> 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:
>
> https://www.postgresql.org/support/versioning/
>
> 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!
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
In-Reply-To: <CANzqJaBefppMx=O6yHEd3osx+5obhWtt31cV8GXP2Kz+4iuvWA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox