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 system user (aiw1 is the default).
  2. Stop RICOH ProcessDirector. Open a command prompt and type:

    stopaiw

  3. Start the embedded PostgreSQL container appropriate for your system.
    • For Docker systems, type:

      docker start rpd-aiwdb-postgres

      If the Reports feature is installed, also type:

      docker start rpd-reports-postgres

    • For Podman systems:

      podman start rpd-aiwdb-postgres

      If the Reports feature is installed, also type:

      podman start rpd-reports-postgres

      Note:
    • Before continuing to the next step, resolve any errors resulted from starting the containers.
  4. Type su - root and press Enter. When prompted, enter the password for the root user and press Enter.
  5. Source the RICOH ProcessDirector system environment variables to the root session. Type:
    source /opt/infoprint/ippd/base/config/ippdprofile
  6. Create an empty temporary directory called updatePostgresql in /opt/infoprint/ippd. Type:
    mkdir /opt/infoprint/ippd/updatePostgresql
  7. Go to /opt/infoprint/ippd/base and locate the updatePostgresql-nnn.zip file, where nnn is the build number. Copy it to /opt/infoprint/ippd/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 /opt/infoprint/ippd/updatePostgresql and continue with the next steps.
  8. Unpack the updatePostgresql-nnn.zip file in /opt/infoprint/ippd/updatePostgresql. Type: 
    cd /opt/infoprint/ippd/updatePostgresql
unzip updatePostgresql*.zip
  9. Go to the directory where you unzipped the file and find: updatePostgresql.sh
  10. To run the script, type:

    ./updatePostgresql.sh --update 2>&1 | tee updatePostgresql.log

  11. Switch to the RICOH ProcessDirector system user ( aiw1 is the default). Type:
    su - aiw1
  12. Verify that the PostgreSQL containers have been upgraded.
    • For Docker systems, type: docker ps -a
    • For Podman systems, type: podman ps -a
      Note:
    • The image name contains the PostgreSQL version for the container similar to this example:
      postgres:17.6-alpine3.22
docker.io/library/postgres:17.6-alpine3.22
  13. List container images to identify the old version that you need to remove:
    • For Docker systems, type: docker images
    • For Podman systems, type: podman images
      Note:
    • The command output displays both the old and the new images, as in the example. Determine the IMAGE ID of the image to be removed by referencing its TAG.
    REPOSITORY   TAG               IMAGE ID       CREATED       SIZE
postgres     17.6-alpine3.22   ef046db6da01   4 weeks ago   279MB
postgres     15.4-alpine3.18   ab8fb914369e   2 years ago   237MB
  14. To remove the old image, type:
    • For Docker systems, type: docker image rm <IMAGEID>
    • For Podman systems, type: podman image rm <IMAGEID>

    where <IMAGEID> is the ID of the image that you want to remove.

  15. Start RICOH ProcessDirector:
    startaiw
  16. Use your browser to log in to the RICOH ProcessDirector user interface and verify that it is working correctly.
  17. Remove the temporary directory: /opt/infoprint/ippd/updatePostgresql.
Parent topic: Upgrading