Upgrading the PostgreSQL database version

When you upgrade RICOH ProcessDirector, you have the option of upgrading the PostgreSQL version during the RICOH ProcessDirector install program or manually, after the install program completes or at a later date.
To manually upgrade the embedded PostgreSQL version:
  1. Make sure that your current PostgreSQL database and RICOH ProcessDirector system are backed up.
  2. Log in to the primary computer as the system administrator that installed RICOH ProcessDirector.
  3. Stop the RICOH ProcessDirector service.
  4. Go to C:\Program Files\Ricoh\ProcessDirector\base\packages and locate the updatePostgresql-nnn.zip file, where nnn is the build number.
      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.
  5. Unzip the updatePostgresql-nnn.zip file to a temporary location.
  6. Go to the directory where you unzipped the file and find: updatePostgresql.ps1
  7. Start a Windows PowerShell session and go to the directory where the ZIP file is unpacked. Type: 
    updatePostgresql.ps1 --update
      Note:
    • At the end of installation process, the PostgreSQL database is updated to the latest version available and displays the message that the PostgreSQL database was successfully updated.
Parent topic: Upgrading