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
Troubleshooting Postgres Performance
IF you think postgres performance is the cause of an application performing badly these sql statements may help
Kill sessions
Vcloud kill idle sessions
Autovacuum Blocking Vacuum
This mainly shows how to kill sessions and look at locking in postgres
