Difference between revisions of "Perform ERP PostgreSQL database maintenance"
(→Objective) |
(→VACUUM PostgreSQL database) |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 14: | Line 14: | ||
=== Make sure no user logged in === | === 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 === | === Clear User Session from Tomcat Manager === | ||
| + | |||
| + | * Open Tomcat Manager | ||
| + | * Go to Application List | ||
=== Stop Apache2 service === | === Stop Apache2 service === | ||
| + | When Apache2 service stopped, all user will not able to access the URL. | ||
| + | |||
| + | Command: | ||
| + | <pre> | ||
| + | sudo service apache2 stop | ||
| + | </pre> | ||
=== 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 Database service purposes is to make sure no more active connection to ERP Database. | ||
| − | === | + | Command: |
| + | <pre> | ||
| + | sudo service postgres restart | ||
| + | </pre> | ||
| + | |||
| + | === VACUUM PostgreSQL database === | ||
| + | |||
| + | Command: | ||
| + | <pre> | ||
| + | </pre> | ||
== Result == | == Result == | ||
Latest revision as of 10:28, 20 December 2021
| Languages: |
ContentsTemplateThis sub-template doesn't display properly when not included. Please see Template:Languages for the complete version. UsageThis 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:
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:
