Check for database consistency on vCenter server 8.x and above

Products

• VMware vCenter Server

Issue/Introduction

When running a vCenter environment there are times that data inconsistencies might be noticed such as:

• missing tags
• time gaps in charts

When such inconsistencies are discovered, these are the options for checking the consistency in an environment running vCenter Server 8.0 and above.

Environment

vCenter Server 8.x
vCenter Server 9.x

Resolution

Below are steps to test the database for consistency.

1. SSH into your vCenter using the root credential.
   
   
2. Run the following command in your vCenter:
   
   /opt/vmware/vpostgres/current/bin/pg_dump -U postgres VCDB > /storage/updatemgr/vcdb.dmp


If the above command succeeds, then the vCenter database is currently healthy. If the above command fails, then there are inconsistencies in the database that need to be addressed. Please open a ticket with Broadcom support to further investigate the database. 

Additional Information

Note: After running the above command, remove the generated file:

rm /storage/updatemgr/vcdb.dmp

 

*To check for database consistency for vCenter server 7.x and below, please see Validate the Consistency of the vCenter Server Appliance 6.5 - 7.0 Databases