MIME-Version: 1.0
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>
In-Reply-To: <CAKAnmm+DcNS_FTGOG9Q3WUQGxxukhqf1rz5jrqzAk0z9W5d59A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 24 Oct 2025 09:20:21 -0400
Message-ID: <CANzqJaBefppMx=O6yHEd3osx+5obhWtt31cV8GXP2Kz+4iuvWA@mail.gmail.com>
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9
 (PostgreSQL 11 streaming replication)
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000364db0641e76a87"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBefppMx%3DO6yHEd3osx%2B5obhWtt31cV8GXP2Kz%2B4iuvWA%40mail.gmail.com>
Precedence: bulk

--0000000000000364db0641e76a87
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Oct 24, 2025 at 8:59=E2=80=AFAM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> On Thu, Oct 23, 2025 at 10:51=E2=80=AFAM 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=3D'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()"

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

--0000000000000364db0641e76a87
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Oct 24, 2025 at 8:59=E2=80=AFAM G=
reg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmail=
.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=
=3D"ltr">On Thu, Oct 23, 2025 at 10:51=E2=80=AFAM Bala M &lt;<a href=3D"mai=
lto:krishna.pgdba@gmail.com" target=3D"_blank">krishna.pgdba@gmail.com</a>&=
gt; wrote:</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Any advic=
e, recommendations, or shared experiences from others who have performed si=
milar migrations would be greatly appreciated.</blockquote><div class=3D"gm=
ail_quote"><div><br></div></div><div dir=3D"ltr" class=3D"gmail_signature">=
<div dir=3D"ltr"><div>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:</div><div><br></div><div><a href=3D"https://www.postgresql=
.org/support/versioning/" target=3D"_blank">https://www.postgresql.org/supp=
ort/versioning/</a></div><div><br></div><div>In particular, note this part:=
</div><div><br></div><div><em style=3D"box-sizing:border-box;color:rgb(0,0,=
0);font-size:15.3333px"><font face=3D"monospace">The community considers pe=
rforming minor upgrades to be less risky than continuing to run an old mino=
r version.</font></em></div></div></div></div></blockquote><div><br></div><=
div>Not only that, but applying minor version update RPMs is=C2=A0<b>fast</=
b>.</div><div>Last weekend, this took 12 seconds to run:</div><div><font fa=
ce=3D"monospace">alias suip=3D&#39;sudo -iupostgres&#39;</font></div><div><=
font face=3D"monospace">suip pg_ctl stop -mfast -wt9999 \<br>=C2=A0 =C2=A0 =
&amp;&amp; sudo yum install -y Pg17.6_RHEL8/*rpm \<br>=C2=A0 =C2=A0 &amp;&a=
mp; suip pg_ctl start -wt9999 \<br>=C2=A0 =C2=A0 &amp;&amp; psql -Xc &quot;=
select version()&quot;</font></div><div><br></div></div><span class=3D"gmai=
l_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature=
"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39=
;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</di=
v></div></div></div></div></div>

--0000000000000364db0641e76a87--