Modifying client access configuration settings

When the PostgreSQL database server is installed, it is configured to allow either encrypted or non-encrypted communications from any other computer. For increased security, you can restrict access to the server by restricting connections to particular IP addresses and requiring encrypted connections for all communications.

This procedure can also be completed using the optional pgAdmin tool. For more information, see Modifying client access configuration settings with pgAdmin.

To modify connection settings:

  1. Stop the AX_Database service.
  2. Locate the pg_hba.conf file in the pgsql91\data subfolder, where the PostgreSQL database server is installed, and open it in a text editor.
  3. The settings that specify the connections permitted are listed at the bottom of the file. There may be one or more settings listed. Use the information in the file and the PostgreSQL documentation, if necessary, to specify the connections you want to permit.

    For example, you can require all connections to use SSL by changing the first value in the default installed setting from host to hostssl.

  4. Save and close the pg_hba.conf file.
  5. Start the AX_Database service.

(C) 2015 ACL Services Ltd. All Rights Reserved.