Date: Sat, 21 Sep 2024 00:33:16 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: glibc updarte 2.31 to 2.38
Message-ID: <20240920223316.muvdgqekzh6dvcii@hjp.at>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <B927CE6F-0A36-4237-BD4D-75CD609F3E89@gmail.com>
 <20240919174349.grrz4w25jmxfk77a@hjp.at>
 <58CD40AA-6316-40B6-89C2-390D16FF5FA0@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="cbmixkaqnzbcroqz"
Content-Disposition: inline
In-Reply-To: <58CD40AA-6316-40B6-89C2-390D16FF5FA0@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/20240920223316.muvdgqekzh6dvcii%40hjp.at>
Precedence: bulk


--cbmixkaqnzbcroqz
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2024-09-19 20:12:13 +0200, Paul Foerster wrote:
> Hi Peter,
> > On 19 Sep 2024, at 19:43, Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
> >=20
> > I wrote a small script[1] which prints all unicode code points and a few
> > selected[2] longer strings in order. If you run that before and after
> > the upgrade and the output doesn't change, you are probably be fine.
[caveats]
> >=20
> > [1] https://git.hjp.at:3000/hjp/pgcollate
> > [2] The selection is highly subjective and totally unscientific.
> >    Additions are welcome.
>=20
> I'm not a Python specialist but I take it that the script need
> psycopg2, which we probably don't have. So I'd have to build some sort
> of venv around that like I had to do to get Patroni working on our
> systems.

I don't use SLES but I would expect it to have an RPM for it.

If you have any test machine which you can upgrade before the production
servers (and given the amount of data and availability requirements you
have, I really hope you do) you should be set.

        hp

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

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

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

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmbt+CUACgkQ8g5IURL+
KF3YnQ/6AkA8dt4N2evM86pGdmaWp00CeVqXkl6giXxDQhRcnJ0E8cq2fqQqAwWy
mrrdfsmemLE6m7DTbVaCLSI8oXJdbMaFNzV+XhpQ9urBtcn5E+Zdh7B4xn2kpIFr
2gesVhBPjHgZUBLPJ7fdPktH+zmVuJNEJKSiZFMby4iaHD77p9cg7BfniBNs+66T
GNjM0VV91lEBKvcJ+8gW4vR1pHd+SanALrk0v26BjDArlg+LHf6y2uZQuhhkTqVi
XzPBGLxRw5fODu9RCl1Pe+dU6HczxlaROZQhxHBRROffKulk+4XBwSb6KOG6inzg
/BZdkU5qqQUDvWbVdp4CSsRs3bB9EZXWU7bOm6B25p3SA3We0hMwhNzHUNYJxWUR
cTSYWSn3KWs5Bv+OE/u+UcLdZjGgyos49AEH4Pl/I5cMuN/t5CWH1aCT8tkBNNRH
3JzV+O4oOmDOiKavLLwPhlvDHMSY0tP9JKYAzwu0i0jcNqNsPEXgQyYghLVU3/SB
IJjm7wa4YSoDuzd0VdnF3z+OtWKynHu1uBKAmkEzxwQrKgx/OKlsNc47qcH9Xjr3
L/kLTIhk+YoAcgUco88pnEFPFb/eppNFTzCoi4tB4FIqwZKjzRPbIt9geOPnQ7RJ
FOPaT6A9z19VXUffsiZs4GMxYQuMgu7x9FcyJhM91mmwyx6mNfg=
=QL5t
-----END PGP SIGNATURE-----

--cbmixkaqnzbcroqz--