AAEP: Access of postgres DB from external system/desktop using pgadmin

Doc ID		SOLN288860
Version:		7.0
Status:		Published
Published date:		14 Apr 2020
Created Date:		05 May 2016

Author:

Sandeep ParvathReddy

Details

AAEP 7.0.2

Problem Clarification

Customer wants to connect to EPM postgresql DB from external desktop using pgadmin tool. Customer does not know the postgres user password supplied during installation.

Cause

Customer forgot the postgres DB password.

Solution

Set the postgres DB password using the command
$AVAYA_HOME/Support/VP-Tools/SetDbPassword/SetDbPassword.sh update -u postgres

[Enter the desired password]

Restart of postgresql, vpms, mmsserver, avpSNMPAgtSvc services after password update.

Make sure there is an entry of the PC/desktop in pg_hba.conf file

host all postgres xxx.xxx.xxx.xxx/xx md5 in the /var/lib/pgsql/data/pg_hba.conf file.
Where xxx.xxx.xxx.xxx is the IP address of the PC/desktop that is being used to access the DB using pgadmin tool.

Note
Backup the original pg_hba.conf file before any changes.

After making changes to the pg_hba.conf configuration file you will need to restart the Postgres Database service on the EPM server for the change to take effect.

As ‘root’ user: service postgresql restart

Avaya -- Proprietary. Use pursuant to the terms of your signed agreement or Avaya policy