name mode size
..
doc 040000
Makefile 100644 1.13kB
README 100644 3.64kB
db_postgres.c 100644 2.96kB
db_postgres.h 100644 1.24kB
km_dbase.c 100644 30.77kB
km_dbase.h 100644 3.98kB
km_pg_con.c 100644 4.42kB
km_pg_con.h 100644 2.83kB
km_pg_type.h 100644 2.44kB
km_res.c 100644 8.2kB
km_res.h 100644 1.3kB
km_val.c 100644 5.22kB
km_val.h 100644 1.14kB
pg_cmd.c 100644 15.41kB
pg_cmd.h 100644 5.27kB
pg_con.c 100644 9.72kB
pg_con.h 100644 3.28kB
pg_fld.c 100644 23.46kB
pg_fld.h 100644 5.43kB
pg_mod.c 100644 13.56kB
pg_mod.h 100644 1.23kB
pg_oid.c 100644 3.71kB
pg_oid.h 100644 4.21kB
pg_res.c 100644 1.77kB
pg_res.h 100644 1.36kB
pg_sql.c 100644 11.48kB
pg_sql.h 100644 4.63kB
pg_uri.c 100644 6.89kB
pg_uri.h 100644 1.91kB
README
postgres Module Greg Fausak August.net Edited by Greg Fausak Copyright © 2003 Greg Fausak __________________________________________________________________ Table of Contents 1. Admin Guide 1. Overview 2. Dependencies 2.1. Kamailio Modules 2.2. External Libraries or Applications 3. Parameters 3.1. retries (integer) 3.2. timeout (integer) 3.3. tcp_keepalive (integer) 3.4. lockset (integer) 4. Functions List of Examples 1.1. Set retries parameter 1.2. Set timeout parameter 1.3. Set tcp_keepalive parameter 1.4. Set lockset parameter Chapter 1. Admin Guide Table of Contents 1. Overview 2. Dependencies 2.1. Kamailio Modules 2.2. External Libraries or Applications 3. Parameters 3.1. retries (integer) 3.2. timeout (integer) 3.3. tcp_keepalive (integer) 3.4. lockset (integer) 4. Functions 1. Overview The module is an implementation of the internal DB API v1 and v2 connector for PostgreSQL server. It has support for reconnecting when the connection is broken. 2. Dependencies 2.1. Kamailio Modules 2.2. External Libraries or Applications 2.1. Kamailio Modules The following modules must be loaded before this module: * No dependencies on other Kamailio modules. 2.2. External Libraries or Applications The following libraries or applications must be installed before running Kamailio with this module loaded: * PostgreSQL library - e.g., libpq5. * PostgreSQL devel library - to compile the module (e.g., libpq-dev). 3. Parameters 3.1. retries (integer) 3.2. timeout (integer) 3.3. tcp_keepalive (integer) 3.4. lockset (integer) 3.1. retries (integer) How many retries to attempt to reconnect if connection to Postgres server becomes broken. Default value is 2 (that means three attempts to submit the query, first will trigger the connection error and two more (the value of this parameter) after resetting the connection). Example 1.1. Set retries parameter ... modparam("db_postgres", "retries", 3) ... 3.2. timeout (integer) Setting this variable to any value larger than zero (which is the default value) enables both a connection timeout and a query timeout. If a connection attempt or a query takes longer than this many seconds, the operation will be aborted and an error will be returned. Note that this timeout is applied to each underlying operation (i.e. for each connection attempt), so depending on circumstances and on the value of the “retries” variable, a single query from the SIP proxy's point of view can take longer than the “timeout”. Example 1.2. Set timeout parameter ... modparam("db_postgres", "timeout", 10) ... 3.3. tcp_keepalive (integer) Enable the TCP keepalive timer and set the number of seconds the connection must be idle before to start sending keepalive packets. Defaults to zero, which disables TCP keepalive packets. Only supported on platforms which understand and support the “TCP_KEEPIDLE” socket option. Example 1.3. Set tcp_keepalive parameter ... modparam("db_postgres", "tcp_keepalive", 600) ... 3.4. lockset (integer) The value is used as power of two to compute the size of the lock set needed to implement the equivalent of REPLACE SQL statement. Default value is 4 (lock set size is 16). Example 1.4. Set lockset parameter ... modparam("db_postgres", "lockset", 6) ... 4. Functions NONE