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

Arun Nukula
1 min read
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.
Never miss a post
New guides on VMware Cloud Foundation, Aria Suite, and infrastructure automation. Follow along in your feed reader and new posts show up as soon as they are published.
Subscribe via RSS