PostgreSQL, by default, only allows local connections. If you would like to open access to network clients or if you are installing the Client Tools on a separate server (installation type 2), modify the following configuration files need to be modified:
postgresql.conf
Code Block | ||
---|---|---|
| ||
listen_addresses = '*' # Allow remote connections on any network interface. # You can also specify an individual IP address or # comma-separated list of IP addresses. |
...
For more detailed information, please see https://www.postgresql.org/docs/10/runtime-config-connection.html.
...
As an example, assume 2 sets of clients need access to the alexandria
database, a data operations team and the CLAIMS Direct Client Tools. The data operations team will need access from any IP address on the 192.168.111.x network and the client tools Client Tools will be updating the database from 10.234.1.6. The following entries would be are required for access:
Code Block | ||
---|---|---|
| ||
# HOST DATABASE USER ADDRESS METHOD # dataops needs access to the entire cluster, hence DATABASE is all host all all 192.168.111.0/24 trust # CLAIMS Direct Client Tools only need access to the alexandria database # and by-default, use a fixed user: alexandria host alexandria alexandria 10.234.1.6 trust |
For a detailed explanation of the host-based access file, please see https://www.postgresql.org/docs/10/auth-pg-hba-conf.html.
...