It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Error Connecting to postgresql database

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

1 answer

1 accepted

0 votes
Answer accepted

Hi,

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

 

Regards

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

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

You rock!

You're welcome!

Like akinadeyemo1 likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you