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.
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 | Number of connections reserved for database maintenance, for example backup or index rebuilding. If you need to simultaneously perform a large number of processes that exceed the default value, change this value accordingly. |
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.
