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!!!
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"
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
Copy and Paste Text:
su - postgres -c "/opt/vmware/vpostgres/current/bin/reindexdb -a > /tmp/reindexdb.log"