1) The LTS upgrade creates an empty cluster for the new postgresql version: pg_lsclusters This empty cluster first needs to be removed: pg_dropcluster 16 main --stop Then: pg_upgradecluster 14 main
On my main pc, that last command collapsed with error - see bug #2078494 On the standby pc (an older machine) it appeared to terminate properly, but failed to copy anything from the v.14 cluster to the new v.16 - the subject of this second bug 2) I'm not sure that any LTS upgrade can be described as a "clean" environment; but my standby pc is as clean as an LTS gets ... Exact steps: as above. 3) I mentioned pg_ ctl (comment #8 and #9), only because (a) it is frequently referred to in the published advices for upgrading postgresql, and (b) it doesn't work (or not easily, anyway!). So I deprecated it, just for the record. It *is* in the standard postgresql package. The man page is easy; there is a config file in /etc/postgresql/main/16/pg_ctl.conf; the program is hidden in /usr/lib/postgresql/16/bin/pg_ctl The following gives installed postgresql packages, agreeing with synaptic search for postgresql: apt list --installed | grep postgresql libreoffice-sdbc-postgresql/noble,noble,now 4:24.8.3~rc2-0ubuntu0.24.04.1~lo1 amd64 [installed,automatic] odbc-postgresql/noble,now 1:16.00.0000-1 amd64 [installed] postgresql-16/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed,automatic] postgresql-client-16/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed,automatic] postgresql-client-common/noble-updates,noble-updates,now 257build1.1 all [installed,automatic] postgresql-client/noble-updates,noble-updates,now 16+257build1.1 all [installed] postgresql-common/noble-updates,noble-updates,now 257build1.1 all [installed] postgresql-contrib/noble-updates,noble-updates,now 16+257build1.1 all [installed] postgresql-doc-16/noble-updates,noble-updates,now 16.4-0ubuntu0.24.04.2 all [installed,automatic] postgresql-doc/noble-updates,noble-updates,now 16+257build1.1 all [installed] postgresql/noble-updates,noble-updates,now 16+257build1.1 all [installed] apt list --installed | grep ecpg libecpg-compat3/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed,automatic] libecpg-dev/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed] libecpg6/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed,automatic] apt list --installed | grep libpq libpq-dev/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed] libpq5/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed,automatic] apt list --installed | grep libpgtypes libpgtypes3/noble-updates,now 16.4-0ubuntu0.24.04.2 amd64 [installed,automatic] -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2081996 Title: After upgrade to 24.04.1 LTS pg_upgradecluster fails to upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-16/+bug/2081996/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
