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

Arun Nukula
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