Showing posts with label DB. Show all posts
Showing posts with label DB. Show all posts

Monday, April 23, 2018

VACUMM postgress from pgadmin3

To Vacumm postgress follow mention methode.

First, start postgress service.

Connect the postgress of minder server from pgadminIII

Navigate to mention location
- servers
- Minder (IP address of the minder server)
- Databases
+ ipmreportdb

right click on ipmreportdb and select Maintanance
















Now select Vacuum



















It will take time and once it is comleted click on Done
Now ANALYZE the pgsql.






































Now Re-index the pgsql.






































Now Restart the postgress.