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