Configuring to extract data to a remote server

Before you can extract data from the PostgreSQL database to an application (such as a business intelligence tool) on a remote server, you must edit two PostgreSQL configuration files.
To configure to extract data to a remote server:
  1. Log in to the primary server.
  2. Go to this directory:
    • /aiw/aiw1/data (Linux)
    • C:\aiw\aiw1\data (Windows)

    • Ricoh ProcessDirector does not create the data directory until you start capturing data in the PostgreSQL database.
  3. Open the pg_hba.conf file in a text editor.
  4. Find the comment line for IPv4 local connections:

    # IPv4 local connections:

    • Ricoh ProcessDirector does not support IPv6 connections for saving data to remote PostgreSQL servers.
  5. Add a line with the IP address and subnet of the remote server.

    For example, to extract data from the PostgreSQL database to an application on a computer at IP address 172.0.0.2 and subnet mask 32, enter the third line shown in this example:

    # IPv4 local connections:
    host  all         all         127.0.0.1/32        trust
    host  all         all         172.0.0.2/32        trust 

    On lines 2 and 3 in the example:

    • The first value specifies the type of connection: host is a plain or SSL-encrypted TCP/IP socket.
    • The second value specifies the databases that users can access.
    • The third value specifies the users who can access the databases.
    • The fifth value specifies the security: trust lets any local user extract data from the database as any PostgreSQL user, including the database super user.

    For information about the choices for each value, see the comments in the pg_hba.conf file.

  6. Open the postgresql.conf file in a text editor.
  7. In the connections and authentication section, find the #listen_addresses line.
  8. To instruct PostgreSQL to listen for notification events on all connections, remove the comment sign (#) and change the ‘localhost’ value to ‘*’.

    listen_addresses = '*'
    For added security, you can specify a comma-separated list of IP addresses instead of *.
  9. Save the file and exit the text editor.
 
Copyright © 2018