Upgrade PostgreSQL

[GianlucaCroci]

I'd like to upgrade the PostgreSQL version on the "Veeam Backup for Microsoft 365" server.
It's a single server with the application and database. Veeam has been upgraded to 8.14, and the current PostgreSQL version is 15.8.
I'd like to upgrade PostgreSQL to 16.13, if possible. From what I've read, this is the most recent version available, although versions 17 and 18 exist.

I currently use "5432" as the database port, but I would use "5433" for the new version.
I don't remember what password I used when installing PostgreSQL the first time (assigned to the "postgres" user).


Here is the configuration line from the "config.xml" file.

<ControllerPostgres ControllerConnectionString="host=server_name;port=5432;database=VeeamBackup365;username=postgres;MaxPoolSize=100;ConnectionIdleLifetime=10" TlsEnabled="False" CertificateThumbprint="" />

I've already tried, but without success:
1. Installing PostgreSQL 16.13
2. Turning off the three Veeam services
3. Using "pg_dumpall" I created a backup of version 15 (pg_dumpall.exe -U postgres -f C:\backup\backup.sql)
4. I recovered the backup on version 16 ("C:\Program Files\PostgreSQL\16\bin\psql.exe" -U postgres -d postgres -f "C:\backup\backup.sql")
5. I edited the "config.xml" file, changing the port from "5432" to "5433"
6. I tried to start the three Veeam services, but none of them started.

I haven't found a specific KB for the in-place upgrade, and especially if there's a way to tell Veeam that the database has changed.
I saw that upgrading from Veeam version 7 to 8 asked for database information, but I haven't found a way to do it afterwards.

Thanks in advance for your help.

[Polina]

Hi Gianluca,

For PostgreSQL upgrades (between both major and minor versions), please follow the same steps described in KB4729.

The list of supported PGSQL versions is provided in our HelpCenter.

Thanks!

[GianlucaCroci]

Hello Polina,

thank's for your reply.

I'd read this KB4729 and others, but I still haven't been able to restart the Veeam services.
It's probably because I don't remember (or know) the password for the current Postgres user.
I'd have to re-enter the credentials.

For example, isn't there a way to move the database to another server? In my case, I wouldn't have to change the server name, just the credentials.

Thank's