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 WindowsEnvironment 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:
- 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.
- Ensure that all Veeam related services are stopped prior to upgrade.
Get-Service Veeam* | Stop-Service
-
Manually Create a Veeam Configuration Backup.
-
Create a backup of the Veeam Database. See this link to backup the database on PostgreSQL
-
Download the latest version of PostgreSQL
-
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 thepgAdmin
is NOT being opened. Open the Task Manager and ensure there’s no process namedpgAdmin.exe
is running.
- 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.
- 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
- 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.
- 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.