vCSA 6 postgreSQL – connect externally through pgAdmin

I recently had to query the VCDB database of vCenter Server 6 but had an appliance deployed and since not using a MS SQL database server I had to do some digging to figure out how i can get access.

My favorite tool to query the database I found to be pgAdmin III but this is installed on my jump server so here are the steps i following to allow pgAdmin to connect to the internal postgresql database on vCSA 6!


  1. Enable SSH for vCSA.
  2. Login as root
    1. shell.set –enabled True
    2. shell
  3. View following 2 files for information on database installation
  4. /etc/vmware-vpx/embedded_db.cfg
    1. General server information and password for superuser. 
  5. /etc/vmware-vpx/
    1. Stores connection information for vCenter server database VCDB (password for vc user
  6. Edit /storage/db/vpostgres/pg_hba.conf
    1. Add following lines to add your own subnets to be able to connect to PG
    2. Host                   all              all                  /           md5
  7. Edit /storage/db/vpostgres/postgresql.conf
    1. Add the line to end of file:   listen_addresses = ‘*’
    2. Restart posgresql /etc/init.d/vmware-vpostgres restart
  8. Open port on vcsa appliance firewall:
    1. iptables -A INPUT -p tcp -m tcp –dport 5432 -j ACCEPT
This should do it and allow you to connect externally through the nice pgAdmin GUI to your database.

Leave a Reply

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

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

Facebook photo

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

Connecting to %s