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

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:
>
> 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!