Service Connection Information

The connection service file allows PostgreSQL connection parameters to be associated with a single service name. That service name can then be specified by a PostgreSQL connection, and the associated settings will be used.

The connection service file can be a per-user service file at `` /.pg_service.conf``, can have its location specified by the environment variable PGSERVICEFILE, or it can be a system-wide file at /etc/pg_service.conf or in the directory specified by the environment variable PGSYSCONFDIR. If service definitions with the same name exist in the user and the system files, the user file takes precedence.

The file uses an INI file format where the section name represents the service name and the parameters are connection parameters; see http://www.postgresql.org/docs/9.1/static/libpq-connect.html for a list. For example:

# comment
[main]
port=5433

If a password is needed to connect, the pgpass option in the Plugin command string can be used to make the Plugin define the needed PGPASSFILE environment variable.

See also

Go back to:

• Automatic Objects Configuration

• PITR Configuration

• Dump Configuration

Go to:

• Testing Database Access

Go back to the main PostgreSQL Configuration page.

Go back to the Dedicated Backup Solutions page.