Difference between revisions of "Perform ERP PostgreSQL database maintenance"

From InfiniteERP Wiki
Jump to: navigation, search
(Created page with "{{RatingArticle}} {{Languages | Documentation_Style_Guide}} == Objective == Anda dapat melakukan maintenance database secara rutin untuk menjaga performa aplikasi ERP: * a ch...")
 
(VACUUM PostgreSQL database)
 
(8 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
== Objective ==
 
== Objective ==
  
Anda dapat melakukan maintenance database secara rutin untuk menjaga performa aplikasi ERP:
+
Anda dapat melakukan maintenance database secara rutin untuk menjaga performa aplikasi ERP.
* a check deposited in the wrong bank account
 
* a bank account out of funds...etc.
 
 
 
  
 
== Recommended articles ==
 
== Recommended articles ==
Line 17: 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 ===
  
=== Restart PostgreSQL database ===
+
Command:
 +
<pre>
 +
</pre>
  
 
== Result ==
 
== Result ==

Latest revision as of 10:28, 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

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