How to reindex the ITBM 1.x Standard Appliance Database

The ITBM standard appliance has it’s own local database. Behind the scenes it is running a vPostgres database to store information about cost and consumptions of your private and public cloud. Over time the database tables can become fragmented and impact performance. 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 ITBM appliance VM.

2. Login to the ITBM appliance as root and change directory to /opt/vmware/vpostgres/current/bin/

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

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

media_1411585578786.png
./reindexdb --dbname postgres --username itfm_cloud_admin

3.1 You should see a bunch of Notices like the following screen indicating which tables were reindexed. NOTE: It may take a minute or two.

media_1411585619811.png

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

media_1411586095233.png
cd /opt/vmware/vpostgres/current/bin/
./reindexdb --dbname postgres --username itfm_cloud_admin

5. Use the following guide to add the reindeitbmdb.sh file to the crontab

Remember sharing is caring!

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.