Upgrading 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:
  • 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

  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.
Parent topic: Downloading and installing security updates