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.
\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.
- Log in to the system where PostgreSQL is installed as an administrator.
- Mount the DVD or ISO image on the system where PostgreSQL is installed.
- Add the PostgreSQL bin directory path to your System Environment Variables. Locate your PostgreSQL
bin
directory, which is usuallyC:\Program Files\PostgreSQL\postgresql_version\bin
, where postgresql_version is the version of the installed PostgreSQL and add the path to the System Variables. - 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.
- Go to the
scripts
directory on the DVD or ISO image and type this command to run the script:perl setupExternalPostgresql.pl - 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.
- 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.
- 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.
- To close the session and return to the command prompt, enter:
\q