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 user (aiw1 is the default).
  3. Type su - root and press Enter. When prompted, enter the password for the root user and press Enter.
  4. Add the system user to the system environment variable.
    Enter this command: export AIWUSER=system_user, where system_user is the user used when you logged in.
  5. Go to /opt/infoprint/ippd/base 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.
  6. Unzip the updatePostgresql-nnn.zip file to a temporary location.
  7. Go to the directory where you unzipped the file and find: updatePostgresql.sh
  8. To run the script, type: 
    updatePostgresql.sh --update
    and press Enter.
      Note:
    • When the script finishes, the command prompt returns: PostgreSQL upgrade completed succesfully.
Parent topic: Upgrading