PostgreSQL is the database server that provides access to the databases required by the EPM web interface. If PostgreSQL is not running or is experiencing difficulties, the EPM pages can exhibit unexpected behavior or cease to respond at all.

Note:

The Experience Portal internal database should not be modified. If you want to modify the database, contact your Avaya technical support representative for assistance.

The following solutions help to identify and troubleshoot issues with PostgreSQL.

Proposed Solution 2: Verifying that the postgres process is running

Procedure

  1. At the Linux command line prompt, enter the ps -edf | grep postgres command.
  2. Is the postgres process listed?

    • If yes, and the problem with the EPM pages continues, reboot the EPM server. If the problem continues, contact your Avaya technical support representative for assistance.

    • If no, try stopping and restarting PostgreSQL as described in Proposed Solution 4: Stopping and restarting PostgreSQL.

Proposed Solution 3: Starting PostgreSQL

Procedure

  1. At the Linux command line prompt, start PostgreSQL by entering the /sbin/service postgresql start command.

    The system responds with a series of messages indicating that the PostgreSQL service is started.

  2. Did this resolve the problem, and does the system now display EPM pages properly?

    • If yes, no further action is required.

    • If no, reboot the EPM server. If the problem continues, contact your Avaya technical support representative for assistance.

Proposed Solution 4: Stopping and restarting PostgreSQL

About this task

If PostgreSQL is running but does not appear to be functioning correctly, you can try stopping and restarting PostgreSQL.

Procedure

  1. At the Linux command line prompt, stop PostgreSQL by entering the /sbin/service postgresql stop command.

    The system responds with a series of messages indicating that the PostgreSQL service is stopped.

  2. At the Linux command line prompt, restart PostgreSQL by entering the /sbin/service postgresql start command.

    The system responds with a series of messages indicating that the PostgreSQL service is started.

  3. Did this resolve the problem, and does the system now display EPM pages properly?

    • If yes, no further action is required.

    • If no, reboot the EPM server. If that does not resolve the problem, contact your Avaya technical support representative for assistance.