How to export database from VMware Aria Automation 8.x

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Collecting and providing databases to Broadcom support in certain scenario's will assist in faster resolution

The steps provided in the article will assist in collecting either the entire database or a specific database

Environment

VMware Aria Automation 8.x

Resolution

Collecting Database(s) for VMware Aria Automation 8.18.x

1. SSH into the primary Aria Automation node and run the following command to capture the entire database:

   • cd /root; for db in cci-db postgres ebs-db provisioning-db abx-db approval-db catalog-db ccs-k3s-db cgs-db cmx-db codestream-db form-db hcmp-db idem-db identity-db lemans-resources-db migration-db project-db relocation-db repmgr-db tango-blueprint-db terraform-db userprofile-db assessment-db vco-db vro-gateway-db; do vracli db dump "$db" > "${db}-data.txt" 2>/dev/null; done; tar -czf "vra-db-backup-$(date +%Y%m%d_%H%M%S).tar.gz" *-data.txt 2>/dev/null && rm *-data.txt 2>/dev/null

2. Capture specific database:

   • cd /root

   • vracli db dump <database name> > <database name.txt>

   • e.g. vracli db dump identity-db > identity-db-data.txt

Collecting Database(s) for VMware Aria Automation (prior to 8.18 versions)

1. Full database (Note: this does not work on VMware Aria Automation 8.18.x)

   • cd /root

   • vracli db dump > vra-db-dump.txt

2. To list the different databases present

   • vracli dev psql

   • \l   (For a prettier output format, first run \x then run \l)

   • \q   (To exit PSQL after getting the database name)

3. Specific database (example)

   • • cd /root

     • vracli db dump <database name> > <database name.txt>

     • e.g. vracli db dump identity-db > identity-db-data.txt

Note: Database restore is not supported due to Kubernetes dependencies. The option of exporting DB should be used only for troubleshooting purpose with Broadcom support.