How to access vCenter DB in VCSA

This article is for environments having psql as data base:

Take ssh to vCenter server appliance

To find the path for psql instance: find /opt |grep psql

Run the below command to activate psql:
/opt/vmware/vpostgres/9.3/bin/psql -U postgres

To list all available DB’s in VCSA use: \l

Select the relevant DB using this command: \c <DB> 
For example: \c VCDB

Leave a Reply