Troubleshooting PostgreSQL issues

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 1: Verifying the PostgreSQL status

Procedure

At the Linux command line prompt, enter the /sbin/service postgresql status command.
Does the system display a message that the PostgreSQL service is running?
- If yes, verify that the postgres process is running as described in Proposed Solution 2: Verifying that the postgres process is running.
- If no, start the PostgreSQL service as described in Proposed Solution 3: Starting PostgreSQL.

Proposed Solution 2: Verifying that the postgres process is running

Procedure

At the Linux command line prompt, enter the ps -edf | grep postgres command.
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

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.
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

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.
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.
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.