How to export embedded Postgres DB from vRLCM 8.x appliance

How to export embedded Postgres DB from vRLCM 8.x appliance

Rated NaN out of 5 stars.

To export the embedded Postgres database from the VMware vRealize Suite LifeCycle Manager Appliance

Log in to the VMware vRealize Automation virtual appliance using SSH.

Change directory using this command:

 cd /tmp

Run this command to create a copy of the database in /tmp

 su -m -c "/opt/vmware/vpostgres/11/bin/pg_dump -Fc vrlcm  > /tmp/vrlcm.sql" - postgres

Note:-Fc switch already provides a compressed file.  No need to bzip.

Use SCP or WinSCP to transfer the vcac.sql file off of the appliance.