Configure pgAdmin to connect to a vRealize Automation instance
search cancel

Configure pgAdmin to connect to a vRealize Automation instance


Article ID: 319571


Updated On:


VMware Aria Suite


Provide detailed instructions on setting up external connections to vRealize Automation to allow remote pgAdmin connections to the embedded vPostgres database.


VMware vRealize Automation 7.x


Setting up pgAdmin
  1. Download & Install the pgAdmin Tool:
  2. SSH into primary appliance
  3. Retrieve the vPostgres password:
xpath /etc/vcac/server.xml "//@password" 2>&1 | grep password | cut -d'"' -f2
The result will look similar to:
  1. Decrypt the password:
vcac-config prop-util -d --p 's2enc~jczzANwNk35PNxcUuRjlGUIe9uF6y/ZkQfbm41j2Ln8='
  1. The result will look similar to:
  1. The password can be saved in the PGPASSWORD environment variable:
  1. Log into vPostgres with the password:
/opt/vmware/vpostgres/current/bin/psql -h localhost vcac vcac
NOTE: This should connect to the database without asking for a password.
NOTE: Additional Tip: Add these two lines to the logged in user .profile in the vRealize Automation appliance so that it is executed at login:

pg_password=$(xpath /etc/vcac/server.xml "//@password" 2>&1 | grep password | cut -d'"' -f2)
export PGPASSWORD=$(vcac-config prop-util -d --p ${pg_password})
  1. Update pg_hba.conf with new trust settings for external connections:
echo "host all all trust" >> /var/vmware/vpostgres/current/pgdata/pg_hba.conf
  1. Edit pg_hba.conf changing md5 to trust for vcac:
vi /var/vmware/vpostgres/current/pgdata/pg_hba.conf
  1. Reload vPostgres configuration:
service vpostgres reload
  1. Open the pgAdmin tool and create a server with hostname (vRAApplianceFQDN or ipAddress) and the Password from step 2.  The database connection should be successful
  2. Use pgAdmin to interact with the database as necessary.
  3. Revert the pg_hba.conf changes when pgAdmin access is no longer needed.

Additional Information

This knowledge article includes directions on how to query a live vPostgres database embedded on the vRealize Automation appliance.  If manual updates to the database are expected, ensure a valid backup is generated before any changes.