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

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.