View source for Perform ERP PostgreSQL database maintenance

{{RatingArticle}}
{{Languages | Documentation_Style_Guide}}
== Objective ==

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

== Recommended articles ==


== Execution Steps ==

<br>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:
<pre>
sudo service apache2 stop
</pre>

=== 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 ===

== Result ==


[[Category:HowTo_Process]]