Enabling access to vPostgres Database:

First, log into the vRA appliance or SSH to it using root account. Next edit pg_hba.conf file

Check for the presence of the line

What this enables, is using the local machine you can use vcac user to login to the database. Since I wanted to access it remotely, I added the following…

Access vRA postgrSQL Database

Login to the vRA Appliance via Putty Run the following commands su – postgres cd /opt/vmware/vpostgres/current/bin ./psql \c vcac – connect to the vcac database \d – list all tables

show all tables also the saas tables from vIDM[/crayon] ATTENTION: DonĀ“t forget the ; at the and of each command. E.g. select * from…