PostgreSQL database connection issues

If the BI tool cannot connect to the PostgreSQL database consider the following troubleshooting suggestions.

  • Make sure that the Reports.json, pg_hba.conf, and postgresql.conf files are set up correctly.
  • If the BI tool is on a computer that has a dynamically allocated IP address, the connection might stop working when the IP address changes.
    For temporary troubleshooting purposes, set the IPV4 local connections to allow address 0.0.0.0/0. This setting allows all IP addresses to connect. If the BI tool can connect with that setting, you can figure out which specific IP addresses need to be added to the allowed list in pg_hba.conf.
  • Verify that the PostgreSQL database is listening on the designated port. By default, the database uses port 5432, though it might have been changed in the Reports.json file.
    To determine whether the database is listening on the port, open a command line and type: netstat -an A list of open ports is displayed.

    If the database is not listening on the port, you might need to stop and restart the PostgreSQL database. The sample commands below use the default values from the Reports.json for the user name, password, and port number. If you changed any of those values, use your values in the command.

    • To stop the database on a Windows server:

      \aiw\aiw1\bin\postgresql\Windows\pgsql\bin\pg_ctl stop -o "-p 5432" -U rpdreports -P testpassword -D \aiw\aiw1\data -l \aiw\aiw1\trace\postgres.trace

    • To start the database on a Windows server:

      \aiw\aiw1\bin\postgresql\Windows\pgsql\bin\pg_ctl start -o "-p 5432" -U rpdreports -P testpassword -D \aiw\aiw1\data -l \aiw\aiw1\trace\postgres.trace

    • To stop the database on a Linux server:

      /aiw/aiw1/bin/postgresql/Linux/pgsql/bin/pg_ctl stop -o "-p 5432" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace

    • To start the database on a Linux server:
      /aiw/aiw1/bin/postgresql/Linux/pgsql/bin/pg_ctl start -o "-p 5432" -U rpdreports -P testpassword -D /aiw/aiw1/data/ -l /aiw/aiw1/trace/postrgres.trace
  • If the database is still not listening on the port:
    • Submit a job to Ricoh ProcessDirector.
    • Restart Ricoh ProcessDirector.
  • If the database is listening on the port, but the BI tool does not connect:
    • Check for firewalls or other network issues.
    • If no other network issues exist, reboot the server that holds the database.
 
Copyright © 2018