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/
/opt/vmware/vpostgres/current/bin/
3. Type: ./reindexdb –dbname vcac –username vcac and press enter
Copy and Paste Text:
./reindexdb --dbname vcac --username vcac
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
Copy and Paste Text:
cd /opt/vmware/vpostgres/current/bin/ ./reindexdb --dbname vcac --username vcac