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) the following configuration files need to be modified:
This change requires a PostgreSQL restart.
For more detailed information, please see https://www.postgresql.org/docs/10/runtime-config-connection.html.
For every client requiring remote access, including the Client Tools processing server in a type 2 installation, a host entry is required. Briefly, a host record consists of space or tab-separated values:
- host: local, host, hostssl, hostnossl
- database: all, sameuser, samerole, replication
- user: all, user name
- address: client IP address(es), CIDR mask is allowed
- method: trust, password, etc.
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 will be updating the database from 10.234.1.6. The following entries would be required for access:
For a detailed explanation of the host-based access file, please see https://www.postgresql.org/docs/10/auth-pg-hba-conf.html.