Perform ERP PostgreSQL database maintenance
Languages: |
Contents
Objective
Anda dapat melakukan maintenance database secara rutin untuk menjaga performa aplikasi ERP.
Recommended articles
Execution Steps
Anyway, the steps to follow are:
Make sure no user logged in
- Login with System Admin Role
- Go to window Session
- Kill user session if necessary for in active session.
Clear User Session from Tomcat Manager
- Open Tomcat Manager
- Go to Application List
Stop Apache2 service
When Apache2 service stopped, all user will not able to access the URL.
Command:
sudo service apache2 stop
Stop ERP Instance from Tomcat Manager
- Open Tomcat Manager
- Go to Application list
- find the InfiniteERP instance
- click STOP button
- wait until the process showing completed on your browser
Restart PostgreSQL database
Restart Database service purposes is to make sure no more active connection to ERP Database.
Command:
sudo service postgres restart