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