Postgres installer cannot run an autogenerated responsefile along with default port in use warning.

Products

• DX Application Performance Management

Issue/Introduction

The Postgres installer cannot run an autogenerated responsefile, It giving the Warning message the PORT  5432 is already in  use ,where as this the default Postgres SQL port .

The issue found in APM  10.8 based  version, and Postgres has been installed manually  as it is no more coming along with APM product.

Environment

Release : 10.8

OS : x86_64 x86_64 GNU/Linux

Resolution

We have identified that Postgres admin user has not created  automatically  while running the installer script.  We created the user manually and modified the pg_hba.conf file .

1:Use PSQL to create a user with a password 

********************************************************

CREATE USER admin WITH  PASSWORD 'yourpass';

2: In pg_hba.conf file

**************************** 

The changes to pg_hba.conf file to allow from access to DB from all IPs

 

3: The Grant privilege will be taken care by the installer.

 

The change that we did for creating the admin user will be handled by the installer in upcoming release of APM .