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

[Abhinav Purokait]

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, 

[Eduardo Alvarenga]

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-- 

[Abhinav Purokait]

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

PFA,