Using the dbcheck tool to troubleshoot issues regarding vPostgres db in vCenter Server Appliance

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:
The dbcheck tool is a powerful diagnostic tool specifically designed for VMware products. It performs a comprehensive series of checks on the embedded vPostgres database, aiming to simplify the detection of inconsistencies. By pinpointing areas that are often difficult to diagnose manually, dbcheck empowers users with valuable insights to troubleshoot database-related issues more effectively.

Environment

VMware vCenter Server Appliance 6.7.x
VMware vCenter Server 7.0.x

VMware vCenter Server 8.0.x

Resolution

Note: In its current alpha version, dbcheck is only supported on vCenter Server Appliance 6.7 and 7.0

1. Download the latest version of dbcheck temporarily attached to this article.

2. Use a file-moving utility of your choice (WinSCP for example) to copy the entire ZIP directory to /root on the node on which you wish to run it.

3. Change your directory to the location of the file, and unpackage the zip:

• cd /root/
• unzip dbcheck-version_number.zip
• chmod +x dbcheck.sh
• chmod +x vpgsql-consistency-check.sh 

4. Run the tool with the command:

./dbcheck.sh
 

Once initiated, the tool will run its diagnostics. 

You can view the detailed output in the window, scrolling up and down to examine the results. Each test is designed to be self-explanatory, clearly presenting its purpose, findings, and any recommended actions. Upon completion, a comprehensive report will be generated and the file path will be displayed, allowing you to easily access the information

Available options:

-m minimum run (No vacuum or consistency check)
-v Run vacuum analyze of DB
-j Run parallel vacuum analyze of DB (quicker if enough vCPU available)
-r Run consistency check
-h help

**To run without vacuum or  consistency check either : **

  ./dbcheck.sh

**or**

  ./dbcheck.sh -m

**To run with vacuum only**

  ./dbcheck.sh -v

**To run with parallel vacuum**

  ./dbcheck.sh -j

**To run with parallel vacuum and consistency check**

  ./dbcheck.sh -j -r