Date: Sat, 25 Oct 2025 17:14:42 +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: <4kmnvgcoxtzcyen3nyv7dunflur7feclzaxh5idfvamx7x6raf@q326opt6dupf>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <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>
 <d45b519f-2cc6-45ea-a9bc-8af28291a86f@aklaver.com>
 <CANzqJaBKEBX9qb_KZpEWem=Os4qz_ASSSKUxeLACxz4anLW-Bg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="5kwejhghnvaqqlqw"
Content-Disposition: inline
In-Reply-To: <CANzqJaBKEBX9qb_KZpEWem=Os4qz_ASSSKUxeLACxz4anLW-Bg@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/4kmnvgcoxtzcyen3nyv7dunflur7feclzaxh5idfvamx7x6raf%40q326opt6dupf>
Precedence: bulk


--5kwejhghnvaqqlqw
Content-Type: text/plain; protected-headers=v1; charset=utf-8
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 10:39:35 -0400, Ron Johnson wrote:
> On Sat, Oct 25, 2025 at 10:21=E2=80=AFAM Adrian Klaver <adrian.klaver@akl=
aver.com>
> wrote:
>=20
>     On 10/24/25 21:50, David Rowley wrote:
>     > 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 otherwi=
se
>     > 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.
>=20
>     Alright that I understand, though not necessarily agree with. I would
>     say lack of testing has more to do with time/money management.
>     Organizations don't want to spend either until: 1) They see the dust
>     settle on what is going to end up in the release. 2) Whether there is
>     anything interesting enough to invest both in moving to a new release.
>     Maybe there is a compelling argument that can be made to get those
>     organizations off the fence. I just don't what it is as you would have
>     to convince them to spend time and money rather then just wait and let
>     the community as a whole do the work.\
>=20
>=20
> Contractual requirements to not run EOL software are a strong motivator to
> migrate to newer versions of OS and RDBMS.

But not to test beta or RC versions. With PostgreSQL's 5 year maintenance
window there is plenty of time to test with final versions before doing
the upgrade. For example, if a company adopted a policy of waitig for
the x.2 release, then test for 6 months before upgrading there production
servers they would still get 4 years of production use out of that major
version before having to upgrade again.

Personally, I usually use the current version for new databases (so if
I started a new project right now I'd use 18.0), but I'm conservative
about upgrades (so I usually don't upgrade to a new major version until
EOL is near and if I still had a 13.x, I'd probably go for 17.6 instead of
18.0). I also admit that I test beta versions only very rarely (basically
only if there is a new feature I'm really excited 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!"

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

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

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmj86VsACgkQ8g5IURL+
KF3TsBAAolbE6EHwtCasZfu0PtGJ+hgDLxhppNcotPhJPr062V0rDCcYERSjpRay
wbFADwuXxRStRyh49T97ri8/J+FR1PuQ8jVc0HO7CLsGx0zstqxedurVHEh4TE8+
D7YUXFIgMPAzQBgRxXGFYryxsvMNYpw7DLyyznEte1A8E76VXs/P06XO9uva8a0Z
w9u2NDqPT8JNVg5qLxlyO8uzV2dxw+5wav7it7Wq5X65pgnCsiL3CBiTOXjNCOHL
QjU2lborRUY20OVtZby7avXQ+HkACchhM/qlkQjUmB17W4Nu+CY9DVp6yMOQAAi+
gFuEAqmgGYQUiBVxSBYq/WWSs/IvRPY4cqhRyH6htJWb5CXuZXWE/9bSWDCAshhF
scxuDStjQNwXH4yhB0puYRb4zf498InWFj0OsayrhNHmQvJcxomTeyh/rZXx8PUi
BQHox385XlBkUNWcaOTy0l32hS7YxgEdOlBvtIkEw93xOE2QDhhhUx+99p2BtDP1
/WHXpZki+jt5XbEs3rYsgOhVTogytf2Ar7F+UjvVxDIGVREvWS4fkCLDga8v0Y0M
93wL/wdGjb6f9U7WhQgzcMHOJdUYRewEAL56/VJzPN7hCAEviZ7+granN/iHPqFf
bA0SkJjqZFJatNtGlAovmAF8Z0JcL1UI249xar5RGdM/ir2u0Rc=
=pLDm
-----END PGP SIGNATURE-----

--5kwejhghnvaqqlqw--