A Postgres database is configured using a set of options understood
by the Postgres
PQconnectdb function. See
for a detailed description. The following is a short summary of the
most useful options:
Name of host to connect to. If this begins with a slash, it specifies Unix-domain communication rather than TCP/IP communication; the value is the name of the directory in which the socket file is stored.
Numeric IP address of host to connect to.
Port number to connect to at the server host, or socket file name extension for Unix-domain connections.
The database name.
PostgreSQL user name to connect as. Defaults to be the same as the
operating system name of the user running the
Password to be used if the server demands password authentication.
Maximum wait for connection, in seconds. Zero or not specified means wait indefinitely.
Any additional command-line options to send to the server at run-time. For example, setting this to ‘-c geqo=off’ sets the session’s value of the ‘geqo’ parameter to ‘off’. For a detailed discussion of the available options, see Postgres documentation7.
This option determines whether or with what priority an SSL TCP/IP connection will be negotiated with the server. There are six modes: ‘disable’, ‘allow’, ‘prefer’, ‘require’, ‘verify-ca’ and ‘verify-full’8.
This parameter specifies the file name of the client SSL certificate.
This parameter specifies the location for the secret key used for the client certificate.
This parameter specifies the file name of the root SSL certificate.
This parameter specifies the file name of the SSL certificate revocation list (CRL).
Kerberos service name to use when authenticating with Kerberos 5 or GSSAPI.
Service name to use for additional parameters.
For PostgreSQL version 8.4, see Chapter 18 in PostgreSQL Manual.
For PostgreSQL version 8.4, see Section 30.17 in PostgreSQL Manual.