vRA 8.x – Quick Tip – How to access embedded PostgreSQL DB

Hi!

Here is another one in our Quick Tip series: accessing the Embedded PostgreSQL Database in vRealize Automation 8.x.

  1. SSH to your vRA appliance as root
  2. Once logged in, run the following command
    vracli dev psql <db-name>
    Examples:
    vracli dev psql catalog-db
    vracli dev psql vco-db
    This will automatically log you in as the postgres user I the pod hosting the specified postgres db.
vracli dev psql <db-name>
  1. *NOTE* The Execution of the ‘vracli dev psql’ command is recorded on the system.
  2. Typeyes‘ if you would like to continue.
  3. Show all tables in this database with: \dt
  4. Run a query e.g. (do not forget ‘;’) : select * from cat_catalogitem;
  5. You can turn on expanded display to show output a bit better: \x
  6. To exit type \q

An example can be found below:

Please use at your own risk! Modifying the embedded PostgreSQL DB content is not supported by VMware.
Accessing it can help you in troubleshooting issues.

Have a nice day!

One thought on “vRA 8.x – Quick Tip – How to access embedded PostgreSQL DB

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s