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…

vRO edit library workflows and actions

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   Get the Script Module ID

  e.g.

  Get Action by name and scriptmodulcategoryid

  e.g

  Update Action allowed operations to edit the operation…