Return to Question

I found this which contains the following paragraphs.

After updating from an alpha or beta release I get an error about CATALOG_VERSION After upgrading from an alpha or beta package, I get an error like:

The database cluster was initialized with CATALOG_VERSION_NO X, but the server was compiled with CATALOG_VERSION_NO Y. This is because the PostgreSQL data format can change between alpha releases - and occasionally even between beta releases if there's a really pressing need.

If you need to access the old data, you will need to use the package version you were running before, and use pg_dump or pg_upgrade. The necessary binaries should have been saved in /var/tmp/postgresql*. Alternatively, look for the old packages in your /var/cache/apt/archives.

I am still struggling, though - I have not found the previous version anywhere yet.

root@ubuntuvm:/home/hugh# cat /usr/lib/systemd/system/postgresql.service # postgresql.service is the meta unit for managing all PostgreSQL clusters on # the system at once. Conceptually, this unit is more like a systemd target, # but we are using a service since targets cannot be reloaded. # # The unit actually managing PostgreSQL clusters is [email protected], # instantiated as [email protected] for individual clusters. [Unit] Description=PostgreSQL RDBMS [Service] Type=oneshot ExecStart=/bin/true ExecReload=/bin/true RemainAfterExit=on [Install] WantedBy=multi-user.target 

(installed by apt install)

hugh@ububtuvm:~$ systemctl status postgresql ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; disabled; vendor p> Active: active (exited) since Sun 2022-09-18 10:47:19 UTC; 31min ago Process: 2349 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Main PID: 2349 (code=exited, status=0/SUCCESS) CPU: 905us Sep 18 10:47:19 ububtuvm systemd[1]: Starting PostgreSQL RDBMS... Sep 18 10:47:19 ububtuvm systemd[1]: Finished PostgreSQL RDBMS. hugh@ububtuvm:~$ journalctl -xeu postgresql.service ░░ Subject: A stop job for unit postgresql.service has begun execution ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ A stop job for unit postgresql.service has begun execution. ░░ ░░ The job identifier is 1675. Sep 18 10:47:19 ububtuvm systemd[1]: Starting PostgreSQL RDBMS... ░░ Subject: A start job for unit postgresql.service has begun execution ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ A start job for unit postgresql.service has begun execution. ░░ ░░ The job identifier is 1675. Sep 18 10:47:19 ububtuvm systemd[1]: Finished PostgreSQL RDBMS. ░░ Subject: A start job for unit postgresql.service has finished successfully ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ A start job for unit postgresql.service has finished successfully. ░░ ░░ The job identifier is 1675.