Difference between revisions of "Perform ERP PostgreSQL database maintenance"

From InfiniteERP Wiki
Jump to: navigation, search
(Stop Apache2 service)
(Stop ERP Instance from Tomcat Manager)
Line 32: Line 32:
  
 
=== Stop ERP Instance from Tomcat Manager ===
 
=== 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 PostgreSQL database ===

Revision as of 09:33, 20 December 2021

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

Result