Date: Sat, 25 Oct 2025 09:23:55 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9
 (PostgreSQL 11 streaming replication)
Message-ID: <r6n3tlkq5cqxqxawrd44qqndy46apijmsxizvbw3baffhqisev@tmlkigxqjd5w>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <8d340169-b500-4048-a665-0700813313a3@aklaver.com>
 <CAKAnmmLDfgYRX8oC6S7jKZyovv6wy72Twq6-hx315GKTowMjew@mail.gmail.com>
 <c319a69b-a667-4536-9aba-d75a4235b786@aklaver.com>
 <CANzqJaBq3hcAUXhSi5ar0=Gw0QxqfmD_E47dxHAex9_D3Yv-WA@mail.gmail.com>
 <2b09033b-d375-488d-9188-17a0f214e823@aklaver.com>
 <CAApHDvo5pLSwD4JVxW8t94Vc88djKrrSyrL-GbQJ=hb2NVT5zg@mail.gmail.com>
 <4babadbd-cc61-43e7-b7fb-3053dcdaadac@aklaver.com>
 <CAApHDvq5-7UO1PZBcizg13_ptE0mP=iKwFKUHqhKjwTmS6YR-A@mail.gmail.com>
 <b465b0d4-5516-46e0-8a60-e24a05169566@aklaver.com>
 <CAApHDvozYU11A7T5XxrzajA6-rqrzRZXfbtToAOu+U_S-Btj=g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="lhfc3zkdyh742lo7"
Content-Disposition: inline
In-Reply-To: <CAApHDvozYU11A7T5XxrzajA6-rqrzRZXfbtToAOu+U_S-Btj=g@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/r6n3tlkq5cqxqxawrd44qqndy46apijmsxizvbw3baffhqisev%40tmlkigxqjd5w>
Precedence: bulk


--lhfc3zkdyh742lo7
Content-Type: text/plain; protected-headers=v1; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9
 (PostgreSQL 11 streaming replication)
MIME-Version: 1.0

On 2025-10-25 17:50:59 +1300, David Rowley wrote:
> On Sat, 25 Oct 2025 at 17:36, Adrian Klaver <adrian.klaver@aklaver.com> w=
rote:
> > I am not following, from your previous post:
> >
> > "Beta versions are meant for test instances. It'd be
> > good if people encouraged their use more often rather than pushing
> > people to defer til GA"
> >
> > That seems to be the opposite of what you say above.
>=20
> I think you think that because you misunderstood what I said in [1].
> I'll rephrase it for you:
>=20
> Because people promote the .0 as not yet production-ready, it means
> that fewer people bother testing with beta and RC versions. Lack of
> beta testing is what causes .0 to contain more bugs than it otherwise
> might, so my suggestion is that we should be encouraging people to run
> beta and RC in their test environments to try to increase the
> stability of .0 versions.

Yes, but in your previous message you wrote:

| I said we shouldn't encourage people to test beta and RC versions,

Note: "shouldn't" instead of "should". Which is exactly the opposite.

I (apparently correctly) assumed that this was a typo, but that wasn't
entirely clear and Adrian obviously took it at face value.

> > > We're talking test servers here.
> >
> > Yes, but the OP was talking about upgrading a production database
> > directly to 18. That was what my reply was referring to and what I was
> > counseling against.
>=20
> You should pay more attention to the quotes above my reply. I don't
> see any of my replies quoting anything about upgrading a production
> database to 18.0.

Well, You came into this thread replying to Adrian, so maybe you should
have paid more attention to what he was (originally) replying to? Or at
least make it clearer that you are changing the subject? Something like
"I agree in this specific case, but in general ..." is often helpful to
alert people that you aren't commenting on the specific problem they are
currently thinking about.

        hjp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--lhfc3zkdyh742lo7
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmj8ewUACgkQ8g5IURL+
KF255g//fgCdzUs25iPjb5GQk8N/AboVssqfnqrRdjvN3W1FV3xADthgsFB5b38v
8EYcrUCNrNh6RBhca93q+zBOmPf6BicrUfQxnGIwOj1iizzsizVva4xI1sQmooOX
qUsvL5qeGlf0czOClc90aIgMaQY5ufkce7hxxXpkQJTJS9EuzjrC4OVtu2mXYmRr
xnuvIJSMKMFqD/+abPDHVKsKoqC+e4DJ9R8z4DSPKtQHOswNm5NcEPQTbNYdDqpy
hriX0For4mIE7X9Gd6g9kmdOM0pISIQwImvAQQ9EBAGAGbF8n8BQTxm9lHjm4MP4
6khKyAoC2hLbr3tRCBqAHwaaKneX/bNoX1JhCQm5raYrwZwyRPTsYdLze72wzjRw
S5uKsh3/5rA0DXC+l6fsb2dzRN0CbkW8mbYFwui6MrdWnkX8gQbwckJeXs/Aqc5f
xV0Pwst+XAyyOLJRzsKhYd5gE4LYOzApcIqLm3ba1XIGYi/nQltYRd9b97+vZ5xU
gUw46lEzSUCzjMbTrzhlr79lrG+jkCGQqjGuLZEc0+6CAErQEBs9/YnWHPa6agwW
k4oL4jTX/UqNUoBT5BhhDPV0NA90HTlSLOFjfgwjcWEk3szTX2wYBYezpSRc81mF
N7yU/w5rV8IFynyiImUMjlCiQbid7US+/rLY1uGvOnsDNi7xRkY=
=Nrcd
-----END PGP SIGNATURE-----

--lhfc3zkdyh742lo7--