vRA 8.x – Quick Tip – How to access embedded PostgreSQL DB Here is another one in our Quick Tip series: accessing the Embedded PostgreSQL Database in vRealize Automation 8.x . SSH to your vRA appliance as root 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 > *NOTE* The Execution of the ‘vracli dev psql’ command is recorded on the system. Type ‘ yes ‘ if you would like to continue. Show all tables in this database with: \dt Run a query e.g. (do not forget ‘;’ ) : select * from cat_catalogitem; You can turn on expanded display to show output a bit better: \x To exit type \q An example can be found below: Please use at your own risk! Modifying the embedded PostgreSQL DB content is not support...
Technical Blogs and Daily IT Infrastructure issues and resolutions