Configuring your own PostgreSQL database

If you cannot use the RICOH ProcessDirector version of PostgreSQL, you can install PostgreSQL on your own and configure it to work with RICOH ProcessDirector.

RICOH ProcessDirector requires PostgreSQL version 15 or higher. You must install the PostgreSQL database before you install RICOH ProcessDirector. For download and installation instructions, refer to these links:

    Note:
  • If PostgreSQL is installed on a different computer on your network, install the PostgreSQL Command Line Tools on the primary computer. Copy or download the PostgreSQL installer to the primary computer and run it. At installation time when you can select the components to install, clear all the options except for Command Line Tools.

RICOH ProcessDirector provides a script to configure a PostgreSQL database installed separately to work with RICOH ProcessDirector. The script is included in the \scripts directory on the RICOH ProcessDirector base product DVD or ISO image.

Running the script requires Perl. Before running the script, make sure that a Perl interpreter is installed on systems where PostgreSQL is installed.

To configure your own PostgreSQL database:
  1. Log in to the system where PostgreSQL is installed as an administrator.
  2. Mount the DVD or ISO image on the system where PostgreSQL is installed.
  3. Add the PostgreSQL bin directory path to your System Environment Variables.
    Locate your PostgreSQL bin directory, which is usually C:\Program Files\PostgreSQL\postgresql_version\bin, where postgresql_version is the version of the installed PostgreSQL and add the path to the System Variables.
  4. Start a command prompt as an administrator. Even if you are logged on to your system as an administrator, you must start the command prompt by selecting Run as administrator from the right-click menu.
  5. Go to the scripts directory on the DVD or ISO image and type this command to run the script:
    perl setupExternalPostgresql.pl
  6. Respond to the prompts as required:
    • When the script asks for a new or an existing database cluster, enter either the path to an existing database cluster or the path where you want to create a new database cluster.
    • When the script asks for a user name, enter the PostgreSQL user name to assign as the owner of the database. You can choose the default PostgreSQL user, a different PostgreSQL user, or specify a new PostgreSQL user to be created. The default user is postgres.
        Important:
      • If you do not know the password for the default user, do not select the default user as the user name.
    • When the script asks for a password, enter the password for the user. A password is only required in these cases:
      • You create a new database cluster.
      • You already created a user for RICOH ProcessDirector to use.
      • You create a new user using this script.
    • When the script asks for an IP address, enter the IP address of the RICOH ProcessDirector primary server.
    • When the script asks for a port number, enter the port used to communicate with RICOH ProcessDirector. The default value is 5432. We recommend using a different port number than the default value when creating a new database cluster. The port number is only required when you create a new database cluster.

    The script creates the AIWDB database in the database cluster. If you create a new cluster, the PostgreSQL database starts automatically.

  7. Optional: To make sure that the database is installed and running, run a command specifying the port number, database name, and user name. For example, this command lets you connect to your PostgreSQL database with specific options:
    psql -p 5444 -d AIWDB -U aiwdbpsql

    where 5444 is the port number, AIWDB is the database name, and aiwdbpsql is the user name.

      Note:
    • If the command fails or you cannot connect to the database, verify that the information you entered is correct.
    • If the command executes correctly, the postgres command line opens.
  8. To close the session and return to the command prompt, enter:
    \q