PostgreSQL database reindexing

To address any issues when the indexes are corrupted.

Steps

1. SStart pgadmin and Indexes.:
2. Select the index for which you see log errors and select Re-index.
3. You may do this while the database is still running.
4. If the issue is not resolved with the log messages, you will need to drop and recreate the index.
5. For this you must top the Application Server and then the Database Server.
6. Make a copy of the DB data folder.