Upgrading the PostgreSQL database

When you upgrade RICOH ProcessDirector, you have the option of upgrading the PostgreSQL database during the RICOH ProcessDirector install program or manually, after the install program completes or at a later date.
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. Go to C:\Program Files\Ricoh\ProcessDirector\base\packages and locate the updatePostgresql-nnn.zip file, where nnn is the build number. Copy it to C:\Program Files\Ricoh\ProcessDirector\updatePostgresql.
      Note:
    • The RICOH ProcessDirector documentation assumes that the product is installed in the default directory. If you chose a different installation directory, you must change the first part of the directory to match the installation directory that you choose.
    • If you have downloaded a newer version of updatePostgresql-nnn.zip for support reasons, you can place the same ZIP file in C:\Program Files\Ricoh\ProcessDirector\updatePostgresql and continue with the next steps.
  5. Unzip the updatePostgresql-nnn.zip file in C:\Program Files\Ricoh\ProcessDirector\updatePostgresql
  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.
Parent topic: Upgrading