Date: Sat, 31 Aug 2024 20:02:13 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL
Message-ID: <20240831180213.ia27hp5ki2vq46nw@hjp.at>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <20240831165445.7kqb4ezzghaysbc7@hjp.at>
 <e7b5c961-39ee-402b-8e00-797508ffd2b9@aklaver.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="glx2drijb6l3fm6p"
Content-Disposition: inline
In-Reply-To: <e7b5c961-39ee-402b-8e00-797508ffd2b9@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/20240831180213.ia27hp5ki2vq46nw%40hjp.at>
Precedence: bulk


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

On 2024-08-31 10:35:01 -0700, Adrian Klaver wrote:
> On 8/31/24 09:54, Peter J. Holzer wrote:
> > 'Tis the season again.
> >=20
> > Ubuntu 24.04.1 has just been released, so many Ubuntu LTS users will now
> > be prompted to upgrade from 22.04 to 24.04.
>=20
> Which I ignore.

At some point I do want to upgrade. Not necessarily at the earliest
oportunity, but for workstations/laptops I'm usually rather quick. This
laptop was originally delivered with a pre-installed Ubuntu 18.04 LTS,
and has since been upgraded to 20.04, 22.04 and now 24.04. Servers are
different. They are usually upgraded when neccessary. Or sometimes new
hardware is ready before support ends ...

But I think our personal preferences are besides the point. Many people
will upgrade Ubuntu in the next weeks or months. So I wanted to give
them a heads-up that this might not be as smooth as expected.


> > A word of warning to those who use Postgresql from the Ubuntu repo (not
> > PGDG):
>=20
> Why I do use the PGDG repo's.

So do I on production systems. But this was just my personal laptop.
But yeah, it reminded me that one of the reasons I prefer the PGDG repos
is that they decouple PostgreSQL upgrades from OS upgrades.


> > As usual, a newer Ubuntu version comes with a newer Postgres version (16
> > instead of 14). Also as usual, I got a message during the upgrade that
> > Postgres 14 is obsolete,. but the binaries have been left installed and
> > I should upgrade to Postgres 16 manually ASAP.
> >=20
> > But after the reboot, PostgreSQL failed to start because it needed a
> > shared library (libldap) which was no longer there. So a normal
> > pg_upgradecluster wouldn't work.
>=20
> sudo apt install libldap-X.x did not work?

It might have worked after reenabling the Ubuntu 22 repo. Or it might
have worked to simply symlink to the newer libldap. Frankly I didn't
try. I had a VM with ubuntu 22 without postgres lying around, so that
seemed like the safeste route.

        hp

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

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

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

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmbTWp8ACgkQ8g5IURL+
KF1kig/+JL/Cyo1fh/eFgxAPAcZ4HK5Xbn1Ci1YppE+SI4kvLX7UwExFFiOIPPIV
pKV6rZXwaKuTQGKI3OHLuAg8B1FwvX8oLOHlvL94aLmPWUtttv4oXmjGazQDMFWb
yeL2FMdpu20JaTwNFpE272t2f/CXmQ/bjJNcoPsog6P5dZpl8pinQoUe/TbvvdU5
84vkEnU2GdshlM+QJqbUaFy+Ery0WFF1nj4HDs9/LZ3LAenYzYUGvcPrnNMD3FGy
LDYxLUAo82tpmmKzWBpb4XcJHstEanhq3Q8oBqgBnXEQzVBxX/imIZ5/x6bLiaKe
pyJOpt9/0Y7ecp4Kc6j4fmgglyMuqwXO3XyBnSSoY0ntcDlqV2htgor7LDMqgKXx
J+AD2j+Zpz6B4obCtzhwu6rbKld1sEAL3YLQ8rCc8Yr09bhQhoGdkwHD1+u8Wj61
WmtC9A1HNRCJ349ugAjYXNTtQG7nRWuVoPopZ9ujxI/9+YB0OQpt52qxunVGn1R5
qnvIaSt4iO+Y9BNJhNFkheta4NK9EU6r3e6rocgG1B5FXZemtp2vu6E1zj+Fiz0F
KSFWVOD5h+h6F7PuzWZL+21CfScq55U4uVy2oslfQFhAJ3/IMohuNyF0HELBxle0
U5lLADtg4/kmKd8t6zIbvXyRKG5cP3MW+LBnR9zhNGTli9awy9Y=
=YcTA
-----END PGP SIGNATURE-----

--glx2drijb6l3fm6p--