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 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. Copy the updatePostgresql-nnn.zip package, where nnn is the build number, to /opt/infoprint/ippd/updatePostgresql.
  8. To generate the MD5 checksum of the package, open a command prompt and enter:
    md5sum /opt/infoprint/ippd/updatePostgresql/updatePostgresql-nnn.zip

    Compare the result with the value provided on the RICOH Software website. If the values do not match, download the package again.

  9. Unpack the updatePostgresql-nnn.zip file in /opt/infoprint/ippd/updatePostgresql. Type: 
    
cd /opt/infoprint/ippd/updatePostgresql
unzip updatePostgresql-nnn.zip
  10. Go to the directory where you unzipped the file and find: updatePostgresql.sh
  11. To run the script, type:

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

  12. Switch to the RICOH ProcessDirector system user ( aiw1 is the default). Type:
    su - aiw1
  13. 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
  14. List container images to identify the old version of PostgreSQL. We recommend removing the old images to clean up the system.
    • 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
  15. 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.

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

Related information:

Downloading security updates
Parent topic: Downloading and installing security updates