Adjusting PostgreSQL Instance Configuration

If you have selected to use an already installed PostgreSQL instance at the Configure PostgreSQL Instance step of the wizard, right after you deploy Veeam Backup for Microsoft 365, make sure that the instance configuration is sufficient for the product performance.

Note

To enhance security of the PostgreSQL instance, we recommend that you also enable the TLS encryption for the PostgreSQL instance traffic. For more information, see this PostgreSQL article.

To adjust the configuration of the PostgreSQL instance, do the following:

On the Veeam Backup for Microsoft 365 server, run the Set-VBOPSQLDatabaseServerLimits cmdlet. The cmdlet generates the necessary PostgreSQL configuration and saves it to a dump SQL file.

Set-VBOPSQLDatabaseServerLimits -OSType <String> -CPUCount <number of CPU cores> -RamGb <RAM in GB> -DumpToFile <file path>

For example,

Set-VBOPSQLDatabaseServerLimits -OSType Windows -CPUCount 8 -RamGb 16 -DumpToFile "c:\temp\PSqlLimitConfig.sql"

On the machine with the PostgreSQL instance where you have deployed the Veeam Backup for Microsoft 365 configuration database, use the psql tool to apply the configuration from the dump file.

The tool is located in the PostgreSQL installation folder.

psql -U <user> -f <file path>

For example,

psql -U postgres -f "C:\config.sql"

After you apply the configuration from the dump file, all changes will be written into the postgressql.auto.conf file located in the PostgreSQL installation folder. This file is loaded when the service starts and takes precedence over the default PostgreSQL configuration file.

Include the pg_stat_statements library to the PostgreSQL configuration. To add the library, you can manually edit the shared_preload_libraries option in the postgres.conf file.

Alternatively, you can do it by by executing the SQL code:

Check the content of the shared_preload_libraries variable.

SELECT * FROM pg_settings

WHERE name = 'shared_preload_libraries';

Add the pg_stat_statements library to the shared preloaded libraries. Do one of the following:

If the shared_preload_libraries value is empty, assign pg_stat_statements to the shared_preload_libraries variable.

ALTER SYSTEM SET shared_preload_libraries = pg_stat_statements;

If the shared_preload_libraries value is not empty, add pg_stat_statements to the current value separated by comma.

ALTER SYSTEM SET shared_preload_libraries = <existing libraries>, pg_stat_statements;

Restart the PostgreSQL service for the new configuration to take effect.
Install the pg_stat_statements extension. The extension is used to analyze the PostgreSQL performance.

CREATE EXTENSION IF NOT EXISTS "pg_stat_statements";