When you deploy the Site Recovery Manager appliance, Site Recovery Manager creates a vPostgres database during the installation process. You can back up and restore the embedded vPostgres database by using PostgreSQL commands.
Always back up the Site Recovery Manager database before updating or upgrading Site Recovery Manager. You also might need to back up and restore the embedded vPostgres database if you need to unregister and then reinstall Site Recovery Manager and retain data from the previous installation, migrate Site Recovery Manager Server to another host machine, or revert the database to a clean state in the event that it becomes corrupted.
- Log in to the Site Recovery Manager Appliance Management Interface as admin.
- In the Site Recovery Manager Appliance Management Interface, click Services, and stop the Site Recovery Manager service.
- Log into the Site Recovery Manager host machine.
- Navigate to the /opt/vmware/vpostgres/current/bin folder that contains the vPostgres commands.
- Create a backup of the embedded vPostgres database by using the pg_dump command.
pg_dump -Fc --username=db_username srmdb > srm_backup_name
You set the username, and password for the embedded vPostgres database when you installed Site Recovery Manager. The database name is
srmdband cannot be changed.
- Perform the actions that necessitate the backup of the embedded vPostgres database.
For example, update or upgrade Site Recovery Manager, uninstall and reinstall Site Recovery Manager, or migrate Site Recovery Manager Server.
- (Optional) Restore the database from the backup that you created in Step 5 by using the pg_restore command.
pg_restore -Fc --username=db_username --dbname=srmdb srm_backup_name
- Start the Site Recovery Manager service.