PostgreSQL

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...

Overview Backup Procedure. Here is the backup procedure to backup the database on PostgreSQL. Using PgAdmin. Launch PgAdmin UI. Enter the Credential. Select the Veeam Database. Right click, and choose Backup. Enter the FileName, browse the path where you want to save the backup. Format keep default Custom. By default postgreSQL backups the DB as .SQL format. Click Backup, and see the progress. Using Powershell Open Powershell Go to Postgres bin folder....

Overview As we know, Veeam has released version 12, which includes PostgreSQL as the default database. For new installations, PostgreSQL will be used by default. However, if you upgraded Veeam from a previous version, you can still using the SQL Express 2016. It is important to note that Veeam uses the SQL Express edition, which have some limitation below: Use of one socket or four cores Use of only 1.4GB per instance 10GB limit for databases As the database grows due to large backup, there is a risk that it might become full, potentially disrupting backups....