How to export database from VMware Aria Automation 8.x

Products

• 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.x

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.