Upgrade to version 4.3.1 fails because of postgresql version

[GeertReijnders]

i want to upgrade my netbox server from version 4.1.10 to version 4.3.1. How can I upgrade my Postgresql version from 12 to a newer version. We run our Netbox Environment on Ubuntu 22.04.5. The upgrade script doesn't do this automatically.

[peterbaumert]

• Install new postgress
• run the postgress migrate to new version
• uninstall old postgress
• be happy

[markkuleinio]

This is how I did it in Debian last time I upgraded it:

https://majornetwork.net/2024/04/postgresql-upgrades-on-debian-linux/

Copy:

• Backup the database (this is important if something goes wrong!)
• Upgrade the system normally (here I’ll use Debian 11 (Bullseye) to 12 (Bookworm) upgrade as en example)
• See that both [email protected] and [email protected] are running (both TCP ports 5432 and 5433 are shown listening with ss -ntl command)
  • PostgreSQL 13 is from Debian 11, PostgreSQL 15 is from Debian 12
• Run sudo pg_dropcluster --stop 15 main
• Run sudo pg_upgradecluster 13 main
• Check that everything works fine
• Check dpkg -l postgresql\* for any old version packages installed, then delete them with apt purge

[GeertReijnders]

This worked for me. Thanks!