From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL |
Date: | 2024-08-31 17:35:01 |
Message-ID: | e7b5c961-39ee-402b-8e00-797508ffd2b9@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/31/24 09:54, Peter J. Holzer wrote:
> 'Tis the season again.
>
> 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.
Which I ignore.
>
> A word of warning to those who use Postgresql from the Ubuntu repo (not
> PGDG):
Why I do use the PGDG repo's.
>
> 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.
>
> 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.
sudo apt install libldap-X.x did not work?
>
> In my case the quickest way to recover was to install postgresql-14 on a
> VM, copy the data direcory into that instance and make a fresh dump,
> then install postgresql-16 on my laptop and restore the dump. Annoying,
> but no big deal for the small test database I keep on my laptop. If you
> have multi-terabyte databases, your situation may be different.
>
> I'm not exactly sure what went wrong (I got some conflicts during the
> upgrade and maybe I shouldn't have invoked apt autoremove?), and you may
> not have this problem, but make sure you have a backup before the
> upgrade.
>
> hp
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2024-08-31 18:02:13 | Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL |
Previous Message | Peter J. Holzer | 2024-08-31 16:54:45 | Upgrade Ubuntu 22 -> 24 may break PostgreSQL |