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_ · Accepted solution]

Hi,

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

Regards

[akinadeyemo1]

I thought this file is required to be edited when you have your postgresql installed on a remote server. Would give a go if that will fix it. 

Thanks

[akinadeyemo1]

Thanks so much @Jack Nolddor _Sweet Bananas_ that fixed the issue. I am able to coonect to my database now.

You rock!

[Jack Nolddor _Sweet Bananas_]

You're welcome!