Moving data to the PostgreSQL database on Windows

Use this procedure to migrate data from the DB2 database to the PostgreSQL database on a Windows primary server.
To move data to the PostgreSQL database on Windows:
  1. Log in to the primary computer as the system administrator.
  2. Open a command prompt and type: wmic process | findstr postgres | findstr -v findstr and press Enter. If the PostgreSQL database is running, you see multiple lines of output. If the PostgreSQL database is not running, you see no output.
  3. If the database is not running, do these steps to start it:
    1. Go to C:\aiw\aiw1\config\.
    2. Open the Reports.json file in a text editor.
    3. Enable the capture property of at least one of the three reporting sections in the Reports.json file: jobStepProgress, jobPrinting, or printerStatus.

      • To enable the capture of Ricoh ProcessDirector property values and put them in the database table, set the JSON property value to enable.
      • To disable the capture, set the value to disable.

      In this example, the captureData property is set to enable:

      "captureData": "enable",

    4. Save and close the Reports.json file.
    5. Start the PostgreSQL database by doing one of these actions:
      • If jobStepProgress is enabled, run a job through a step in any workflow. You can submit a new job or continue a current job.
      • If jobPrinting is enabled, print a job to any printer.
      • If printerStatus is enabled, disable or enable any printer.
  4. In the command prompt, type: ippdprofile.cmd and press Enter.
  5. Type: C:\aiw\aiw1\bin\migrateReports.pl and press Enter. As the script runs, it identifies and displays the tables that are migrating from the DB2 database to the PostgreSQL database.
  6. During the migration process, the migrateReports.pl asks for a username and password for Ricoh ProcessDirector . Enter the username and password for a Ricoh ProcessDirector user and press Enter.
  7. A prompt is displayed asking you if the rptdb database should be removed. To remove the database, type Yes and press Enter. To remove the database later, type No and press Enter.
  8. Verify that the data has been migrated to the PostgreSQL database correctly. Connect to the PostgreSQL database using your business intelligence tool or by using a PostgreSQL command line to verify the database tables contain the correct entries.
    If there is a problem, inspect the files containing the migrated data in the C:\aiw\aiw1\migrate\ directory. These files consist of .csv and .sql files. If the files have been migrated successfully, you can delete the C:\aiw\aiw1\migrate\ directory.

    If you encounter any problems, contact a Ricoh support representative.