Getting an error while first time authenticating the db (psql)

Question

While configuring for the first time bamboo in local system it gives an error

'Error accessing database: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "my_user" '

I tried with multiple user but it shows the same error

PFA,

Abhinav Purokait · Answer

I already did this troubleshoot and restarted the psql also but the error remains the same

PFA,

Eduardo Alvarenga · Answer

Hello @Abhinav Purokait,

Welcome to Atlassian Community!

Your PostgreSQL Database configuration is probably not allowing connections with a password from localhost. To fix that, please review your Database pg_hba.conf file and add/fix the following entries:

local all all trust
host all 127.0.0.1/32 trust

PostgreSQL needs to be restarted to apply any changes to the logon ACLs.

You can find more details on this KB article:

* FATAL: Ident authentication failed for user - Unable to connect to PostgreSQL

Best regards,

Eduardo Alvarenga
Atlassian Support APAC

--please don't forget to Accept the answer if the reply is helpful--