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:
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.