postgres Module

Greg Fausak

August.net

Edited by

Greg Fausak

Copyright © 2003 Greg Fausak

Revision History
Revision $Revision: 5898 $$Date$

Table of Contents

1. Admin Guide
1.1. Overview
1.2. Dependencies
1.2.1. OpenSIPS Modules
1.2.2. External Libraries or Applications
1.3. Exported Parameters
1.3.1. exec_query_threshold (integer)
1.3.2. max_db_queries (integer)
1.4. Exported Functions
1.5. Installation and Running

List of Examples

1.1. Set exec_query_threshold parameter
1.2. Set max_db_queries parameter

Chapter 1. Admin Guide

1.1. Overview

Module description

1.2. Dependencies

1.2.1. OpenSIPS Modules

The following modules must be loaded before this module:

  • No dependencies on other OpenSIPS modules.

1.2.2. External Libraries or Applications

The following libraries or applications must be installed before running OpenSIPS with this module loaded:

  • PostgreSQL library - e.g., libpq5.

  • PostgreSQL devel library - to compile the module (e.g., libpq-dev).

1.3. Exported Parameters

1.3.1. exec_query_threshold (integer)

If queries take longer than 'exec_query_threshold' microseconds, warning messages will be written to logging facility.

Default value is 0 - disabled.

Example 1.1. Set exec_query_threshold parameter

...
modparam("db_postgres", "exec_query_threshold", 60000)
...

1.3.2. max_db_queries (integer)

The maximum number of database queries to be executed. If this parameter is set improperly, it is set to default value.

Default value is 2.

Example 1.2. Set max_db_queries parameter

...
modparam("db_postgres", "max_db_queries", 2)
...

1.4. Exported Functions

NONE

1.5. Installation and Running

Notes about installation and running.