Perform ERP PostgreSQL database maintenance - Revision history

Wikiadmin: /* VACUUM PostgreSQL database */

2021-12-20T03:28:45Z

‎VACUUM PostgreSQL database

Wikiadmin: /* Restart PostgreSQL database */

2021-12-20T03:28:20Z

‎Restart PostgreSQL database

Wikiadmin: /* Restart PostgreSQL database */

2021-12-20T02:34:43Z

‎Restart PostgreSQL database

Wikiadmin: /* Stop ERP Instance from Tomcat Manager */

2021-12-20T02:33:28Z

‎Stop ERP Instance from Tomcat Manager

Wikiadmin: /* Stop Apache2 service */

2021-12-20T02:32:13Z

‎Stop Apache2 service

Wikiadmin: /* Stop Apache2 service */

2021-12-20T02:31:18Z

‎Stop Apache2 service

Wikiadmin: /* Clear User Session from Tomcat Manager */

2021-12-20T02:30:40Z

‎Clear User Session from Tomcat Manager

Wikiadmin: /* Make sure no user logged in */

2021-12-20T02:30:05Z

‎Make sure no user logged in

Wikiadmin: /* Objective */

2021-12-19T23:58:24Z

‎Objective

Wikiadmin: Created page with "{{RatingArticle}} {{Languages | Documentation_Style_Guide}} == Objective == Anda dapat melakukan maintenance database secara rutin untuk menjaga performa aplikasi ERP: * a ch..."

2021-12-19T23:50:23Z

Created page with "{{RatingArticle}} {{Languages | Documentation_Style_Guide}} == Objective == Anda dapat melakukan maintenance database secara rutin untuk menjaga performa aplikasi ERP: * a ch..."

New page

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

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

== Execution Steps ==

<br>Anyway, the steps to follow are:

=== Make sure no user logged in ===

=== Clear User Session from Tomcat Manager ===

=== Stop Apache2 service ===

=== Stop ERP Instance from Tomcat Manager ===

=== Restart PostgreSQL database ===

== Result ==

[[Category:HowTo_Process]]

← Older revision		Revision as of 03:28, 20 December 2021
Line 48:		Line 48:

	=== VACUUM PostgreSQL database ===		=== VACUUM PostgreSQL database ===
		+
		+	Command:
		+	<pre>
		+	</pre>

	== Result ==		== Result ==

@@ Line 46: / Line 46: @@
 sudo service postgres restart
 </pre>
 == Result ==

← Older revision		Revision as of 02:34, 20 December 2021
Line 39:		Line 39:

	=== Restart PostgreSQL database ===		=== 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>

	== Result ==		== Result ==

@@ Line 24: / Line 24: @@
 === Stop Apache2 service ===
 Command:
 <pre>

← Older revision		Revision as of 02:31, 20 December 2021
Line 24:		Line 24:

	=== Stop Apache2 service ===		=== Stop Apache2 service ===
		+	Command:
		+	<pre>
		+	sudo service apache2 stop
		+	</pre>

	=== Stop ERP Instance from Tomcat Manager ===		=== Stop ERP Instance from Tomcat Manager ===

@@ Line 32: / Line 32: @@
 === Stop ERP Instance from Tomcat Manager ===
+* Open Tomcat Manager
 === Restart PostgreSQL database ===

← Older revision		Revision as of 02:30, 20 December 2021
Line 19:		Line 19:

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

← Older revision		Revision as of 02:30, 20 December 2021
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 ===

@@ Line 3: / Line 3: @@
 == 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.
 == Recommended articles ==