Configure PostgreSQL to Accept External Connections

About this task

If you want to use the tagslist API, you must set up PostgreSQL and the indexing service, which are installed when you install the web-based clients provided with Historian for Windows. This topic describes how to configure PostgreSQL to accept external connections, which is required for you to use the tagslist API.

Procedure

  1. Log in to the machine on which the web-based clients are installed.
  2. Access the following folder: <web-based clients installation drive>:\ProgramData\GE\Operations Hub\historian-postgres\data
  3. Access the pg_hba.conf file in a text editor.
  4. In the IPV4 local connections section, add a line to enable PostgreSQL to trust connections from the local network.
    host all all 10.0.0.0/8 trust. In this example, the local network IP address begins with 10. Similarly, you must enter the first 8-bit value of the IP addresses in your local network.
  5. Save the file.
  6. Access the postgresql.conf file (located in the same folder) in a text editor.
  7. In the Connection Settings section, modify the listen_addresses key to listen_addresses='*'
  8. Save the file.
  9. Restart the GE Historian PostgreSQL Database service.