Updating the PostgreSQL database

Keep your system secure and compatible by updating to the latest supported PostgreSQL version. This ensures you have the newest features, performance improvements, and security fixes.
    Important:
  • You can only use this procedure with a PostgreSQL database provided by Ricoh with RICOH ProcessDirector. If you install and manage the database separately, you must download and install updates directly from the publisher.
  • Take a snapshot or backup of the RICOH ProcessDirector system to avoid data loss.
  • Verify that antivirus or other security software that locks and scans files is still disabled on the RICOH ProcessDirector system.
To manually upgrade the embedded PostgreSQL database:
  1. Log in to the primary computer as the user who installed RICOH ProcessDirector.
  2. Stop all RICOH ProcessDirector and Feature Manager services.
  3. Create an empty temporary directory called updatePostgresql in C:\Program Files\Ricoh\ProcessDirector.
  4. Copy the updatePostgresql-nnn.zip package, where nnn is the build number, to C:\Program Files\Ricoh\ProcessDirector\updatePostgresql.
  5. To generate the MD5 checksum of the package, open a command prompt and enter:
    certUtil -hashfile C:\Program Files\Ricoh\ProcessDirector\updatePostgresql\updatePostgresql-nnn.zip MD5

    Compare the result with the value provided on the RICOH Software website. If the values do not match, download the package again.

  6. Start a Windows PowerShell session and go to the directory where the ZIP file is unpacked to start the PostgreSQL update: 

    cd "C:\Program Files\Ricoh\ProcessDirector\updatePostgresql"
.\updatePostgresql.ps1 --update *>&1 | Tee-Object -FilePath updatePostgresql.log

      Note:
    • If you receive an error message indicating that the script cannot be run due to execution policy restrictions, you can temporarily allow the script to run. Type: 

      Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass

      This change applies only to the current PowerShell session and does not affect the system-wide execution policy.

  7. Start the RICOH ProcessDirector service.
  8. Use your browser to log in to the RICOH ProcessDirector user interface and verify that it is working correctly.
  9. Remove the temporary directory: C:\Program Files\Ricoh\ProcessDirector\updatePostgresql.

Related information:

Downloading security updates
Parent topic: Downloading and installing security updates