The easiest way to see the interactions that are going from vc to the database then you can increase logging to see these sql statements.
Author: yvonneknowsdatabases
remove vm from inventory
If a vm is being highlighted in the vpxd logs and the reason for vc to crash then it’s always useful to remove this vm from the database to see if it will allow vc to startup.
switch to postgres user in linux
On the VCSA you may want to switch to the postgres user to run some postgres commands it may be locked out. The commands below show how to make this user available
VRA Postgres Replication
If postgres replication is broken you may as well reset it up as opposed to trying to manually move the logs. Here’s how to do it
postgres on vcops
to login
su – postgres /opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433
Backup and restore VCDB on windows
To backup the postgres database manually on windows
Troubleshooting SQL Server Performance
If your concerned your SQL server database is the cause of a performance issue then these commands might help
