Search This Blog

Friday, March 17, 2023

Set Postgresql Limit on Veeam Database

When you make changes to hardware for Veeam Database or want to set limit, you are required to re-run this command.

Note: Require to restart postgresql services once execute the below command. If your VBR is using MFA-enabled, you need to turn it off first

Set-VBRPSQLDatabaseServerLimits

a) VBR + Database on the same server

Run 

Set-VBRPSQLDatabaseServerLimits

b) VBR Database on a different server/ remote server

Example: 16 cores, 30GB RAM

Set-VBRPSQLDatabaseServerLimits -OSType Windows -CPUCount 16 -RamGb 30

Set-VBRPSQLDatabaseServerLimits -OSType Linux -CPUCount 16 -RamGb 30

For more detail, please refer to https://helpcenter.veeam.com/docs/backup/powershell/set-vbrpsqldatabaseserverlimits.html?ver=120