Setting the retention period for data in the PostgreSQL database

You can retain the values of Ricoh ProcessDirector job and printer properties in the PostgreSQL database for as long as you want. For each table in the database, you can specify a different retention period.

  • Do not complete this procedure if you are only using the WritePropsToReportsDatabase step to capture data.
To set the retention period for data in the PostgreSQL database:
  1. Log in to the primary computer.
  2. Open the Reports.json file in a text editor.

    If any JSON values include Unicode characters, open the file with an editor that saves text in UTF-8 format.

    The file is in the config directory:

    • /aiw/aiw1/config/Reports.json (Linux)
    • C:\aiw\aiw1\config\Reports.json (Windows)

    We recommend that you keep a copy of the original Reports.json file. If the updated file contains JSON syntax that is not valid, you can compare the updated file with the original file.

  3. Find the cleanup property in each section where you want to set a retention period: jobStepProgress, jobPrinting, or jobStepProgress.
    • To set a retention period for the data in the table, set the value to on.
    • To keep data in the table indefinitely, set the value to off.

    In this example, the cleanup property is set to on:

    "cleanup": "on",
  4. In each section where you set the value of the cleanup property to on, find the cleanupRetention and cleanupRetentionUnit properties.
  5. Set the value of the cleanupRetention property to an integer that specifies the length of the retention period.
  6. Set the value of the cleanupRetentionUnit property to a unit of measure:
    • seconds
    • minutes
    • days
    • weeks
    • months
    • years

    This example shows a three-month retention period for the data in the database table:

    "cleanupRetention": "3",
    "cleanupRetentionUnit": "months",
  7. When you finish specifying data retention periods, save the Reports.json file and exit the text editor.
Copyright © 2018