Loading...
Loading...
This article documents the procedure for upgrading the underlying PostgreSQL database engine software that Veeam Backup for Microsoft 365 uses for its configuration database and cache databases. Unless indicated elsewhere by Veeam or under the advisement of Veeam Support, upgrading the PostgreSQL database engine in use by Veeam Backup for Microsoft 365 should be considered optional. Before upgrading, ensure that the version of PostgreSQL software being upgraded to is supported by Veeam Backup for Microsoft 365.
Identify the Configuration Database Location Review the Veeam Backup for Microsoft 365 configuration to identify the current database connection information. On the machine where Veeam Backup for Microsoft 365 is installed open the following file in a text editor: C:\ProgramData\Veeam\Backup365\Config.xml Look for the node named ControllerPostgres. On that line will be the current database connection information. Example 1: Using VB365 Installer-deployed PostgreSQL Instance <ControllerPostgres ControllerConnectionString="host=vb365srv;port=5432;database=VeeamBackup365;username=postgres;maxpoolsize=100;connectionidlelifetime=10" /> In this example, we can see that the PostgreSQL server is named vb365srv, the configuration database is named VeeamBackup365, and we can tell that SSPI authentication is being used because there is no password= parameter. Example 2: Using Remote Dedicated PostgreSQL Instance <ControllerPostgres ControllerConnectionString="host=pgsqlsrv;port=5432;database=VeeamBackup365;username=veeam365svc;password=AQAAANCMnd8BFdERjHoAwE%2FCl%2BsBAAAAnyPJ1ttvw06By6Ldd2NKOkEHjdXl7buhzxlW4MjXMBBqLZQGWWjXHgyM%3D;maxpoolsize=100;connectionidlelifetime=10;PasswordEncrypted=True" /> In this example, we can see that the PostgreSQL server is named pgsqlsrv, the configuration database is named VeeamBackup365, the user is named veeam365svc, and native password-based authentication is in use because there is a passsword= parameter configured.
Veeam Integration
Learn more about where this data comes from
BugZero Plan
Streamline upgrades with automated vendor bug scrubs
BugZero Prevent
Wish you caught this bug sooner? Get proactive today.