How to reindex the vRA7 Appliance Database

The vRealize Automation 7 appliance provides the UI and portal functionality for vRA (among other things). 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. Always snapshot or backup your appliance before attempting this procedure. NOTE: This procedure is not currently supported by VMware. Use at your own risk!!!

vradb

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

2. Using SSH, login to the vRA appliance and enter the following and press enter:

su - postgres -c "/opt/vmware/vpostgres/current/bin/reindexdb -a > /tmp/reindexdb.log"
vRA-REINDEXDB

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

Screen Shot 2016-01-04 at 1.15.39 PM

Copy and Paste Text:

su - postgres -c "/opt/vmware/vpostgres/current/bin/reindexdb -a > /tmp/reindexdb.log"

Use the following guide to add the reindesxvra7.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.