Database server

The database server hosts the PostgreSQL or IBM DB2 database for RICOH ProcessDirector. All database requests originate from the active primary server.
  1. Verify that the database server meets the minimum hardware requirements.

    Minimum hardware requirements for the database server

    Resource Requirement
    Processor x86 computer capable of running a supported 64-bit Linux operating system
    CPU cores Minimum 4 physical CPU cores
    RAM Minimum 8 GB available RAM
    Hard-drive space 200 GB free
    Network Reliable, low-latency connection to the file server (NFS) and the database server
  2. Evaluate your storage requirements based on the following factors:
    • Job volume — Each job creates database records. High-volume environments generate more database activity.
    • Document tracking — If you use document processing features, the database stores records for each document within a job, significantly increasing storage requirements.
    • Retention periods — Longer retention periods mean more historical data in the database.
    • Reports — If you use reporting features, report data accumulates over time.

    Plan for growth by using a storage system that supports online expansion.

  3. Verify that the database server meets the following performance recommendations:
    • Use fast storage (SSD or equivalent) for the database data directory to minimize I/O latency.
    • Allocate sufficient RAM for the database to cache frequently accessed data.
    • Position the database server on the same network segment as the primary servers to minimize query latency.
  4. If you run the database server on a virtual machine (VM), define the VM guest so that the number of dedicated CPUs meets or exceeds the minimum requirements.

    Do not overcommit physical CPU resources or memory on the virtual host.