Perform ERP PostgreSQL database maintenance

From InfiniteERP Wiki
Jump to: navigation, search
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.

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: 



Result








					

						Retrieved from "https://wiki.infinite-erp.co.id/index.php?title=Perform_ERP_PostgreSQL_database_maintenance&oldid=2997"