PostgreSQL - Revision history

Monica: /* Status of running module */

2014-06-10T07:19:38Z

‎Status of running module

2014-06-10T07:19:07Z

2013-11-04T11:17:21Z

‎Example

2013-06-05T11:45:21Z

‎Example

2013-04-05T13:23:42Z

2013-03-28T11:01:01Z

‎Example

2013-03-28T10:59:43Z

‎Example

2013-03-28T10:59:18Z

‎Example

2013-03-28T10:49:34Z

2013-03-27T12:57:21Z

@@ Line 148: / Line 148: @@
 Where:
-*''conns=1'' - number of defined connections
+*'''conns=1''' - number of defined connections
-*''failed=0'' - number of connections that failed to connect
+*'''failed=0''' - number of connections that failed to connect
 *'''format=Total|Failed|Errors|AvgExecTime'''
@@ Line 155: / Line 155: @@
 Above ''postgres'' is the name of the connection you defined.
-*''Total'': total number of queries that were executed(or tried to execute) on this connection
+*'''Total''': total number of queries that were executed(or tried to execute) on this connection
-*''Failed'': number of failed queries on this connection
+*'''Failed''': number of failed queries on this connection
-*''Errors'': number of errors when trying to execute queries(including retrials) on this connection
+*'''Errors''': number of errors when trying to execute queries(including retrials) on this connection
-*''AvgExecTime'': average execution time per query (miliseconds)
+*'''AvgExecTime''': average execution time per query (miliseconds)
 '''See also'''

← Older revision		Revision as of 07:19, 10 June 2014
Line 142:		Line 142:
	account=yateadmin		account=yateadmin

		+	=== Status of running module ===
		+	Example of "status pgsqldb" command output:
		+
		+	name=pgsqldb,type=database,format=Total\|Failed\|Errors\|AvgExecTime;conns=1,failed=0;postgres=1\|0\|0\|2
		+
		+	Where:
		+	*''conns=1'' - number of defined connections
		+	*''failed=0'' - number of connections that failed to connect
		+
		+	*'''format=Total\|Failed\|Errors\|AvgExecTime'''
		+	'''postgres=1\|0\|0\|2'''
		+
		+	Above ''postgres'' is the name of the connection you defined.
		+	*''Total'': total number of queries that were executed(or tried to execute) on this connection
		+	*''Failed'': number of failed queries on this connection
		+	*''Errors'': number of errors when trying to execute queries(including retrials) on this connection
		+	*''AvgExecTime'': average execution time per query (miliseconds)

	'''See also'''		'''See also'''

← Older revision		Revision as of 11:17, 4 November 2013
Line 148:		Line 148:
	* [[Register]]		* [[Register]]
	* [[Modules]]		* [[Modules]]
		+
		+	[[Category:PostgreSQL]] [[Category:Database]]

← Older revision		Revision as of 13:23, 5 April 2013
Line 1:		Line 1:

−	~~This~~ module is used to make the connection between Yate and one or more PostgreSQL databases.	+	The module pgsqldb is used to make the connection between Yate and one or more PostgreSQL databases.

	When using this module for storing CDRs, also read [call.cdr] section in [[Register\|Register]].		When using this module for storing CDRs, also read [call.cdr] section in [[Register\|Register]].

← Older revision		Revision as of 11:01, 28 March 2013
Line 123:		Line 123:

	Example of configuring an PostGreSQL database account in file pgsqldb.conf:		Example of configuring an PostGreSQL database account in file pgsqldb.conf:
−
−	~~pgsqldb.conf~~

	[yateadmin]		[yateadmin]

← Older revision		Revision as of 10:59, 28 March 2013
Line 123:		Line 123:

	Example of configuring an PostGreSQL database account in file pgsqldb.conf:		Example of configuring an PostGreSQL database account in file pgsqldb.conf:
		+
		+	pgsqldb.conf

	[yateadmin]		[yateadmin]

@@ Line 126: / Line 126: @@
   [yateadmin]
   host=localhost
   database=yateadmin
   user=postgres
@@ Line 134: / Line 135: @@
 The name between [] will be used in other configuration files to set the used account.<br>
-If you need to store CDRs, you will have to use register.conf file, so that Yate will know which connection to make.
+If you need to store CDRs, you will have to use [[Register|register.conf]] file, so that Yate will know which connection to make.
 register.conf

@@ Line 1: / Line 1: @@
-This module is used to make the connection between Yate and a PostgreSQL database.
+This module is used to make the connection between Yate and one or more PostgreSQL databases.
 When using this module for storing CDRs, also read [call.cdr] section in [[Register|Register]].
 ===Check if module is loaded===

← Older revision		Revision as of 12:57, 27 March 2013
Line 35:		Line 35:

	If line name=pgsqldb,.... don't appear in the list that means that module is not loaded. Install devel packages. Then restart Yate for changes to take place.		If line name=pgsqldb,.... don't appear in the list that means that module is not loaded. Install devel packages. Then restart Yate for changes to take place.
		+
		+	==== Solutions ====
		+
		+	* A reason that the module is not loaded may be that you don't have the devel packages installed.
		+	Install devel packages. Then run '''./configure''' and '''make''' in Yate's sources.
		+
		+	* Another reason could be that the module is not listed in file '''yate.conf'''. If parameter '''modload''' is disabled, then you have to check in [modules] section that module is enabled.
		+	'''yate.conf'''
		+	[general]
		+	modload=no
		+
		+	[modules]
		+	pgsqldb.yate=yes

	===Configuration===		===Configuration===