Set up PostgreSQL to Store Tracking Information

This section describes how to set up the PostgreSQL back end.

The example actions and commands are for IDOL components running on a Microsoft Windows platform, and a PostgreSQL server running on a Linux platform. Other combinations of platforms are possible.

Install the SQL Database

The following Linux command example installs the latest stable PostgreSQL server, using the default port (5432). You can use any recent, stable version (on any port).

sudo apt-get install postgresql

You can test that your server is up with psql.

For Windows, you can install PostgreSQL from the following Web site:

For more detailed installation instructions, refer to the PostgreSQL wiki.

Set up the Database and Table

This section describes how to set up the database in PostgreSQL on Linux. On Windows, you can complete the tasks by using Pgadmin.

The PostgreSQL installation creates a user for you.


If you want to set up document tracking in an existing IDOL installation that uses the deprecated IndexTasks component, you must also add the following statements for the type table:

INSERT INTO type(typeid, type, is_error, is_terminal)

Database Access Permissions

On Windows, you can modify the configuration in Pgadmin by selecting the appropriate item on the left pane, and then clicking Tools/Server Configuration.

To modify the database access permissions

  1. Find the pg_hba.conf host-based authentication file by inspecting the PostgreSQL configuration file. The following lines in the postgresql.conf file identify the location:

    hba_file = '/etc/postgresql/9.1/main/pg_hba.conf'  # host-based authentication file

    The location of the postgresql.conf file can vary, depending on your version and operating system. On Linux, you can run the following command to find the path to the configuration file:

    ps -ef | grep postgres
  2. Modify the pg_hba.conf configuration file, which you located in Step 1, to allow your IDOL components to access the database. Find the following section, and add appropriate lines for your client IP addresses.

    # TYPE  DATABASE    USER           ADDRESS             METHOD
    host    all     trust

    For simplicity, you can set the USER field to all. HPE recommends that you use a secure METHOD, such as md5, after you have tested the system.

  3. Allow PostgreSQL to accept connections. In the postgresql.conf file, find the listen_addresses parameter and uncomment or modify it:

    listen_addresses = '*'
  4. Save and close the pg_hba.conf and postgresql.conf files.

  5. Restart PostgreSQL, by using the following command (on Linux):

    sudo -u postgres /etc/init.d/postgresql restart