In the second part of the series “Migrating VBR to PostgreSQL LPart 2]” we will have a look at the migration itself.
First of all:
Update Veeam via the recommended way:
https://helpcenter.veeam.com/docs/backup/vsphere/upgrade_vbr.html?ver=120
You will not be able to migrate the database with the upgrade itself.
After the upgrade, you can use the following guide to migrate the configuration database to PostgreSQL: https://helpcenter.veeam.com/docs/backup/vsphere/vbr_config_migrate_to_postgresql.html?ver=120
This howto describes the 5 easy steps to do the migration based on the guide above.
If you want to know how to install the PostgreSQL on a external Debian-based server check the howto in part 1 of this small series: https://community.veeam.com/blogs-and-podcasts-57/migrating-vbr-to-postgresql-part-1-4277
Step 1 Stop and disable all your jobs to make sure nothing change while you are doing the migrate.
Step 2 Create a configuration database backup
Go to Main Menu → Configuration Backup:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/a6bb398d-719c-4124-a788-2cb0af036596.png)
Enable configuration backup, encryption and click on Backup now:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/3a163e15-18f5-4fda-b79d-11bbe07d8ea1.png)
Step 3 Restore the configuration database
Click on Restore:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/8d1eed9d-1b93-427b-804f-4a6cb6de4e6d.png)
Select Migrate instead of Restore:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/1f9fd42a-62c8-4015-9086-0616438521aa.png)
Choose your created configuration backup and click on Analyze:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/327ed190-a4eb-4cd8-a21c-0f6aca05126a.png)
Next:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/a504240d-a111-4354-bd43-251efcb6d142.png)
Enter your password and click on Validate
Now choose PostgreSQL as your database and the corresponding hostname as instance name (Port should be 5433). The authentication will be your defined user on the PostgreSQL server:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/5bc9bcb7-4788-402d-b295-0042a7967f76.png)
Remove the Backup existing database flag because your database is completely new and click Restore:
![](https://uploads-eu-west-1.insided.com/veeam-en/attachment/fcbee3ac-e795-42e8-a3d7-9c4d770da24a.png)
If everything went well click Finish and open the client.
Step 4 Tune your setup using the following PowerShell command:
https://helpcenter.veeam.com/docs/backup/powershell/set-vbrpsqldatabaseserverlimits.html?ver=120
Set-VBRPSQLDatabaseServerLimits -OSType Linux -CPUCount 2 -RamGb 4
and restart the PostgreSQL daemon on the external Debian server.
Step 5 Don’t forget:
-
Configure all necessary settings to ensure that you have a working configuration database backup. You can now perform a backup of your new configuration database in the Configuration Backup Settings window.
-
Enable your backup jobs and backup copy jobs. Take a closer look at your backup infrastructure to ensure that everything is working as expected.