Error Connecting to postgresql database

akinadeyemo1

Hi all,

Please I have installed jira 8.5 on centos-8 and also have postgresql 9.6 installed on it.

I have created a database, user and encrypted password for user.

On first attempt to connect to postgresql database I got an error message

Fatal: Ident authentication failed for user "username"

I did not have to touch the hba.conf because the database is installed on same server with Jira.

I have recreated the user again with same password using "ALTER USER" command to ensure I am getting my password details right.

I also noticed that

i) I am not able to connect to postgresql db on command line using

psql -h localhost -p 5432 -U <username> <databasename>;

Got similar error message

"psql: FATAL: Ident authentication failed for user "username"

 

Please what solution can you recommend?

Thanks for your help.

Akin

Jack Nolddor [Sweet Bananas]

Hi,

Have you edited the The pg_hba.conf File to allow user and password credentials? You must use md5 authentication.

 

Regards