4.4.2 When an Instance was Created with the initdb Command

Connection settings

The default setting only permits local connections from the client to the database. Remote connections are not accepted.

Change "listen_addresses" in postgresql.conf to perform remote connection.

All remote connections will be allowed when changed as shown below.

Example

listen_addresses = '*'

Also, configure the parameters shown below in accordance with the applications and number of client command connections.

Parameter name	Parameter description
superuser_reserved_connections	Used to reserve the connections required to manage Symfoware Server. Calculate and set this value based on the description below: Connections in continuous use during activation of an instance using the autovacuum feature: 3 Connections required by administrator for maintenance operations such as creating backups or rebuilding indexes: 1 Connections used during pgAdmin operations; Number of clients used
max_connections	Set the value as: numberOfSimultaneousConnectionsToInstance + superuser_reserved_connections

Parameter name

Parameter description

superuser_reserved_connections

Used to reserve the connections required to manage Symfoware Server. Calculate and set this value based on the description below:

Connections in continuous use during activation of an instance using the autovacuum feature: 3
Connections required by administrator for maintenance operations such as creating backups or rebuilding indexes: 1
Connections used during pgAdmin operations; Number of clients used

max_connections

Set the value as:

numberOfSimultaneousConnectionsToInstance + superuser_reserved_connections

Client authentication information settings

When trying to connect from a client to a database, settings are required to determine whether the instance permits connections from the client - if it does, then it is possible to make settings to determine if authentication is required.

See

Refer to "The pg_hba.conf File" in "Server Administration" in the PostgreSQL Documentation for details.