How to reindex the vCAC Appliance Database

The vCAC 6 appliance provides the UI and portal functionality for vCAC. Behind the scenes it is running a vPostgres database to store information about approvals, catalog items and some logging. Over time the database tables can become fragmented and impact performance of the portal. Note: this may not help performance with any of the tabs served in the Infrastructure Tab as those come from the Windows IaaS box. Always snapshot or backup your appliance before attempting this procedure. NOTE: This procedure is not currently supported by VMware. Use at your own risk!!!

1. Login to vCenter and take a snapshot of your vCAC Appliance VM.

2. Using SSH, login to the vCAC appliance and change directory to /opt/vmware/vpostgres/current/bin/

media_1409950393407.png
/opt/vmware/vpostgres/current/bin/

3. Type: ./reindexdb –dbname vcac –username vcac and press enter

reindexcmd

Copy and Paste Text:

./reindexdb --dbname vcac --username vcac

You should see a bunch of Notices like the following screen indicating which tables were reindexed.

results

If you want to run this on a regular schedule, create an shell script file named reindexvcac6.sh with the following lines and save it

vCACsh

Copy and Paste Text:

cd /opt/vmware/vpostgres/current/bin/
./reindexdb --dbname vcac --username vcac

Use the following guide to add the reindesxvcac6.sh file to the crontab

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.