Overview

Veeam version 12 introduces to use PostgreSQL as the Database Engine. To ensure the database engine is keep updated, and any potential vulnerabilities, you need to manually update the PostgreSQL to the latest version periodically.

Check current PostgreSQL version

To check the current PostgreSQL version:

Using Powershell

  • Open Powershell on Administrative task, and run:
postgres.exe --version

Result:

postgres (PostgreSQL) 15.1

This method requires the PostgreSQL to be registered on Windows Environment Variables

Using PostgreSQL Shell

  • Launch SQL Shell.
  • Enter the serverNmae, or localhost, and type the credential
Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
psql (15.1)
  • After login, run the following:
postgres=# select version();
  • Result:
version
------------------------------------------------------------
 PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit(1 row)

Before you begin:

  1. Ensure all jobs, policies, and tasks are stopped, and those that are scheduled to run are disabled.

Double check to ensure that there are no jobs or restore tasks occurring.

  1. Ensure that all Veeam related services are stopped prior to upgrade.
Get-Service Veeam* | Stop-Service
  1. Manually Create a Veeam Configuration Backup.

  2. Create a backup of the Veeam Database. See this link to backup the database on PostgreSQL

  3. Download the latest version of PostgreSQL

  4. Check the compatibility version to ensure the version is compatible with Veeam Backup & Replication.

If you want to upgrade the pgAdmin version to the latest version as well, ensure that the pgAdmin is NOT being opened. Open the Task Manager and ensure there’s no process named pgAdmin.exe is running.

  1. If you want to upgrade PostgreSQL and its all component including pGAdmin, Stack Builder, you can just run the installer directly.

pgAdmin is not required but may be helpful if future direct interaction with the database is needed. If not selected, it can always be installed separately at a later time.

Stack Builder is not required and should be unselected.

  1. If you want to Install/upgrade PostgreSQL without upgrading its other components such as PgAdmin, you can use the unattended installation mode. Run the installer from a command line with the following options:
-mode unattended --disable-components pgAdmin,stackbuilder

Example:

C:\temp\postgresql-15.3-2-windows-x64.exe --mode unattended --disable-components pgAdmin,stackbuilder
  1. After the upgrade completes, restart the Veeam Backup Server.

Note: The Veeam services are set to “Automatic (Delayed Start).” After the reboot, please allow the services time to start before opening the Veeam Backup & Replication Console.

  1. Remember to enable the Jobs you stopped in Step 1.

Conclusion

By upgrading the Database engine on Veeam server periodically, it can help reduce any bugs and fix any potential security issues and vulnerabilities. I hope these procedures are helpful.