Perform ERP PostgreSQL database maintenance

Languages:

English Template This sub-template doesn't display properly when not included. Please see Template:Languages for the complete version. Usage This template is designed to simplify Template:Languages, by allowing a simpler syntax for adding new languages. Each language is included by calling this template with the following parameters: Language code (e.g. fr) (optional) Page name - if not supplied the page is automatically worked out based on where the language template is included. This template should not be used anywhere except in the Languages template. </noinclude> | Translate this article...

Objective

Anda dapat melakukan maintenance database secara rutin untuk menjaga performa aplikasi ERP.

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: