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.
- 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.