Difference between revisions of "Perform ERP PostgreSQL database maintenance"
(→Restart PostgreSQL database) |
(→VACUUM PostgreSQL database) |
||
Line 48: | Line 48: | ||
=== VACUUM PostgreSQL database === | === VACUUM PostgreSQL database === | ||
+ | |||
+ | Command: | ||
+ | <pre> | ||
+ | </pre> | ||
== Result == | == Result == |
Latest revision as of 10:28, 20 December 2021
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
VACUUM PostgreSQL database
Command: