Configuring your own PostgreSQL database

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 either the PostgreSQL server or the PostgreSQL client on the primary computers.RICOH ProcessDirector uses the command line tools included in those packages to access PostgreSQL commands and send requests to the other system. If you install the PostgreSQL server, you can still configure RICOH ProcessDirector to use a database on a different system. You do not need to create a database on this system.

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.

Make sure that the existing database cluster or the target database cluster directory can be accessed by the postgres user.

To configure your own PostgreSQL database:
  1. Download and install a supported version of PostgreSQL as indicated above.
  2. Mount the RICOH ProcessDirector base product DVD or ISO image on the system where PostgreSQL is installed.
  3. Switch the current user to the postgres user, which is the default system user account created during the installation of PostgreSQL. Type this command:
    sudo su - postgres
  4. Add the PostgreSQL bin directory path to your system environment variables.
    Enter this command:

    export PATH=/usr/pgsql-version/bin:$PATH

    where version is the PostgreSQL version. For example: export PATH=/usr/pgsql-15/bin:$PATH

      Note:
    • You can add this path to the .profile configuration file for the postgres user. Thus, the path is always available for the postgres user.
  5. Go to the scripts directory on the DVD or ISO image and type this command to run the script:
    ./setupExternalPostgresql.pl
      Note:
    • If the postgres user does not have permissions on the scripts directory, you can copy the script to a directory where the postgres user has permissions. For example, you can copy the script to /var/lib/pgsql where the postgres user has already permissions to execute commands.
  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 one of the RICOH ProcessDirector primary servers.
    • 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. Open /var/lib/pgsql/data/pg_hba.conf and find this line (usually at the end): host all all ipAddress/32 trust

    where ipAddress is the IP address you specified in the script in the step above.

    Copy the line and change the IP address to the IP address of the other primary server. When you complete editing, there should be two lines, one with the IP address for each primary server.

  8. To reload the file, run this command: pg_ctl -D /var/lib/pgsql/data reload
  9. 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.
  10. To close the session and return to the command prompt, enter:
    \q
  11. Install either the full PostgreSQL package or the PostgreSQL client on both primary servers.
Parent topic: Installing PostgreSQL