LXXXIV. PostgreSQL Functions
Introduction
PostgreSQL database is Open Source product and available without cost. Postgres, developed originally in the UC Berkeley Computer Science Department, pioneered many of the object-relational concepts now becoming available in some commercial databases. It provides SQL92/SQL99 language support, transactions, referential integrity, stored procedures and type extensibility. PostgreSQL is an open source descendant of this original Berkeley code.
Requirements
To use PostgreSQL support, you need PostgreSQL 6.5 or later,
PostgreSQL 7.0 or later to enable all PostgreSQL module
features. PostgreSQL supports many character encoding including
multibyte character encoding. The current version and more
information about PostgreSQL is available at http://www.postgresql.org/
and http://techdocs.postgresql.org/.
Installation
In order to enable PostgreSQL support, --with-pgsql[=DIR]
is required when you compile PHP. DIR is the PostgreSQL
base install directory, defaults to /usr/local/pgsql. If
shared object module is available, PostgreSQL module may
be loaded using extension directive in php.ini or dl() function.
Runtime Configuration
The behaviour of these functions is affected by settings
in php.ini.
Table 1. PostgreSQL configuration options
Name Default Changeable
pgsql.allow_persistent "1" PHP_INI_SYSTEM
pgsql.max_persistent "-1" PHP_INI_SYSTEM
pgsql.max_links "-1" PHP_INI_SYSTEM
pgsql.auto_reset_persistent "0" PHP_INI_SYSTEM
pgsql.ignore_notice "0" PHP_INI_ALL
pgsql.log_notice "0" PHP_INI_ALL
For further details and definition of the PHP_INI_* constants see ini_set().
Here's a short explanation of the configuration directives.
pgsql.allow_persistent boolean
Whether to allow persistent Postgres connections.
pgsql.max_persistent integer
The maximum number of persistent Postgres connections per
process.
pgsql.max_links integer
The maximum number of Postgres connections per process,
including persistent connections.
pgsql.auto_reset_persistent integer
Detect broken persistent links with pg_pconnect(). Needs
a little overhead.
pgsql.ignore_notice integer
Whether or not to ignore PostgreSQL backend notices.
pgsql.log_notice integer
Whether or not to log PostgreSQL backends notice messages.
The PHP directive pgsql.ignore_notice must be off in order
to log notice messages.
