VMware Embedded Databases location, user names and passwords

Hello All,

Good Day.

Well, I found it very difficult in many cases to locate the database location and its user name and password during troubleshooting of multiple issues and thought of creating a consolidated list so which helps me in saving some time next I want to use the same. Hence this post.

So lets start exploring.

  1. vCenter Server Appliance
DB Location: /opt/vmware/vpostgres/current/bin/
How to Access: /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres

2. Site Recovery Manager

DB Location: /opt/vmware/vpostgres/current/bin
How to Access: /opt/vmware/vpostgres/current/bin/psql -U srmdb
On an Appliance navigate to /opt/vmware/srm/conf/ to find the login and password
cat /opt/vmware/srm/conf/db:srmdb 
For Database name
cat /opt/vmware/srm/conf/db.cfg

3. vSphere Replication Management Server

DB Location: /opt/vmware/vpostgres/current/bin/
How to access: /opt/vmware/vpostgres/current/bin/psql -U vrmsdb

4. NSX for vSphere

To Access NSX for vSphere Manager database, First log in to the root shell of the NSX Manager using this KB.