Perform ERP PostgreSQL database maintenance

From InfiniteERP Wiki
Revision as of 09:31, 20 December 2021 by Wikiadmin (talk | contribs) (Stop Apache2 service)
Jump to: navigation, search

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

Command:

sudo service apache2 stop

Stop ERP Instance from Tomcat Manager

Restart PostgreSQL database

Result