Database Administration

In general, you should refer to your database administrator to perform administrative tasks with your PostgreSQL DB. However, there is a set of tools packaged for PostgreSQL databases, named pgadmin, which is available at https://www.pgadmin.org/download/.

The two most common activities seen are:

• PostgreSQL database compression
• PostgreSQL database reindexing.

Steps

1. Stop the Application Server and then the Database Server.
2. Make a copy of the DB data folder.
3. Start pgadmin and go to VACUUM FULL ANALYZE Maintenance:

4. Review the log of the process:

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.