org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user

[Deleted user]

(Note: Question was edited as I was able to solve a side issue.)

I'm setting up Confluence (via web interface on localhost:8090) and I'm stuck at the step "Set up your database" which returns the following error:

Problem connecting to your database

SQLState - 28000
org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "confluence"

Here's how the database was set up:

[root@linuxbox ~]# postgresql-setup initdb 

[root@linuxbox ~]# systemctl start postgresql 

[root@linuxbox ~]# systemctl enable postgresql 

[root@linuxbox ~]# passwd postgres 

[root@linuxbox ~]# useradd confluence 

[root@linuxbox ~]# su - postgres 

[postgres@linuxbox ~]# psql -U postgres 


postgres=# CREATE ROLE confluence WITH LOGIN; 

postgres=# \password confluence 

postgres=# \q 


[root@linuxbox ~]# createdb -E utf8 -l C -T template0 confluencedb -O confluence 

[root@linuxbox ~]# su - postgres 

[postgres@linuxbox ~]# psql -U postgres 


postgres=# GRANT ALL PRIVILEGES ON database confluencedb TO confluence; 

The user "confluence" is able to connect to PostgreSQL by command line.
 

What's wrong?  Thanks in advance if you can shed some light on this.

[Deleted user · Accepted solution]

It was a glitch. I've solved the issue by reinstalling Confluence (by relaunching the installer atlassian-confluence-6.10.0-x64.bin). Now Confluence correctly connects to the database.

[Moses Thomas]

@[deleted]:D  good that  you  are able  to  get confluence running!

Best!.

[Moses Thomas]

@[deleted]Please see documentation https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html on  connecting  confluence to  Postgres, it should work  if you are doing  the right thing

Best!

[Deleted user]

Yes, I've already read the documentation -- that's usually what I do before installing things. ;)