Configuring to extract data to a remote server

If you need to send data collected in the Reports database to another application that does not support the REST protocol, you can use PostgreSQL commands to extract the data following this procedure.

To configure to extract data to a remote server:

Log in to the primary server.
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.
Open the pg_hba.conf file in a text editor.
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.
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.
Open the postgresql.conf file in a text editor.
In the connections and authentication section, find the #listen_addresses line.
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 *.
Save the file and exit the text editor.
Stop the PostgreSQL database.
Note: The sample commands use the default values from the Database Settings for the user name, password, and port number. If you changed any of those values, use your values in the command.
Open a command prompt and type this command:
- on a Windows server:
  - \aiw\aiw1\bin\postgresql\Windows\pgsql\bin\pg_ctl stop -o "-p 5432" -U rpdreports -P testpassword -D \aiw\aiw1\data -l \aiw\aiw1\trace\postgres.trace
    or
  - <RPD Install Directory>\PostgreSQL\bin\pg_ctl stop -o "-p 5432" -U rpdreports -P testpassword -D \aiw\aiw1\data -l \aiw\aiw1\trace\postgres.trace
- on a Linux server:
  - /aiw/aiw1/bin/postgresql/Linux/pgsql/bin/pg_ctl stop -o "-p 5432" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace
    or
  - /usr/pgsql-14/bin/pg_ctl stop -o "-p 5432" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace
Start the PostgreSQL database.
- on a Windows server:
  - \aiw\aiw1\bin\postgresql\Windows\pgsql\bin\pg_ctl start -o "-p 5432" -U rpdreports -P testpassword -D \aiw\aiw1\data -l \aiw\aiw1\trace\postgres.trace
    or
  - <RPD Install Directory>\PostgreSQL\bin\pg_ctl start -o "-p 5432" -U rpdreports -P testpassword -D \aiw\aiw1\data -l \aiw\aiw1\trace\postgres.trace
- on a Linux server:
  - /aiw/aiw1/bin/postgresql/Linux/pgsql/bin/pg_ctl start -o "-p 5432" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace
    or
  - /usr/pgsql-14/bin/pg_ctl start -o "-p 5432" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace
1. Log in to RICOH ProcessDirector
2. Click the Administration tab.
3. In the left pane, click Reports ⇒ Data Collectors .
4. In the upper right corner, if the database status is Not connected, refresh your browser to change it to Connected.

RICOH ProcessDirector™ for Windows

Configuring to extract data to a remote server

Related information: