How to Back Up and export the Embedded vPostgres Database for vSphere Replication and VMware Live Site Recovery (SRM) Appliances

Products

• VMware Live Recovery

Issue/Introduction

This article outlines the steps to back up the embedded vPostgres database of vSphere Replication and VMware Live Site Recovery appliances for troubleshooting. 

Environment

VMware vSphere Replication
VMware Site Recovery Manager
VMware Live Site Recovery

Resolution

vSphere Replication

root@vSphere-Replication [ /home/admin ]# cat /opt/vmware/hms/conf/embedded_db.cfg
EMB DB INSTALL_DIR='/opt/vmware/vpostgres/current'
#EMB DB TYPE='PostgreSQL'
#EMB DB SERVER='127.0.0.1'
#EMB DB PORT='5432'
EMB DB INSTANCE='vrmsdb'
EMB DB USER='vrmsdb'
EMB DB PASSWORD='abc##########################123'
EMB DB STORAGE='/var/lib/vrmsdb'
EMB_DB MAX CONNECTIONS='150'

root@vSphere-Replication  [ ~ ]# cd /opt/vmware/vpostgres/current/bin/

root@vSphere-Replication  [ /opt/vmware/vpostgres/current/bin ]# ./pg_dump -Fc -U vrmsdb > /home/admin/vSphere-Replication.bak
Password: abc##########################123

root@vSphere-Replication [ /opt/vmware/vpostgres/current/bin ]# cd /home/admin

root@vSphere-Replication [ /home/admin ]# ls -lah *vSphere-Replication*
-rw------- 1 root root 2.2M Mar 25 15:32 vSphere-Replication.bak

root@vSphere-Replication [ /home/admin ]# sudo chown admin -R vSphere-Replication.bak

 

VMware Live Site Recovery

root@VLSR [ ~ ]# cd /opt/vmware/vpostgres/current/bin/

root@VLSR [ /opt/vmware/vpostgres/current/bin ]# ./pg_dump -Fc -U srmdb  -d srmdb > /home/admin/VLSR.bak

root@VLSR [ /opt/vmware/vpostgres/current/bin ]# cd /home/admin

root@VLSR [ /home/admin ]# ls -lah *VLSR*
-rw------- 1 root root 4.2M Mar 25 15:32 VLSR.bak

root@VLSR [ /home/admin ]# sudo chown admin -R dcwipvmsrm001.backup

Login to the respective appliance using WinSCP as admin

Navigate to /home/admin folder and export the backup file to your desktop. 

Additional Information

Back Up and Restore the Embedded vPostgres Database