Problem connecting to database error while setting up database in Confluence

Hello, I am getting this error while configuring POSTGRESQL parameters when setting up the database in confluence.

I am getting the following error. I have verfied the database configuration multiple times and the configuration seems to be ok in PostGreSQL. Need your support here. Thanks.

Problem connecting to your database

SQLState - 28000
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "X.X.X.X", user "confluenceadmin", database "postgresdb", SSL off



3 answers

0 votes

Your database is not set up to allow connections from your server, so I'm afraid your "configuration seems to be ok in PostGreSQL" is not right.

Have a look at the database's pg_hba.conf file - it needs a rule in there to allow confluenceuser to connect from x.x.x.x and use the databases.

Thanks Nic for your response May I know how to verify this in GUI PGAdmin tool?

I'm not sure, I've always edited the file by hand.

What works for my server here is

host    confluenceuser         confdb         x.x.x.4/32    md5

host    jirauser         jiradb         x.x.x.8/32    md5

Replace the with your server's ip address obviously.

Hi Nic, I am not an expert in CLI. I tried looking at this option in PGAdmin, but not sure where to change this. May I know how to do this in CLI?

snapshot.JPGsnapshot2.JPGI have attached the snapshots as well.

Are you sure you should be connecting Confluence to postgresdb?   Is that not the admin database in there?  Should it not be confluencedb?

That may be a diversion though, just something I would want to check.  

Going back to the error message: There are no pg_hba.conf settings in that GUI I can see, you're going to have to edit it directly to allow the connection.

0 votes
Gonchik Tsymzhitov Community Champion Nov 12, 2017


Sorry, have you read a documentation from PostgreSQL?


For me just interesting how did you check a configuration multiple times? 

As I understand you are check on "app" level, I mean you just check for user about access to DB. 

But "network" level have you test? like (telnet postgreshost 5432) from confluence. (short instruction , normal documentation

And double check "auth" level? like (psql -h postgreshost -d postgresdb -U confluenceadmin -W ) (for more info



I hope it helps for troubleshooting. And please, try to use cli, therefore you will fix so faster 



Gonchik Tsymzhitov

Thanks Gonchik. I will try this out and will let you know early next week. Sorry I had been traveling this week and couldn’t access the system.

Gonchik Tsymzhitov Community Champion Nov 18, 2017


You are welcome. 

I will wait your follow up after checks and reconfigure.

0 votes
Ann Worley Atlassian Team Nov 21, 2017

@SACHIN MENON you may edit the pg_hba.conf file from pgAdmin by using the Tools menu and choosing Server Configuration>pg_hba.conf:

Screen Shot 2017-11-21 at 1.17.45 PM.png

To add a new line, double click the blank line:

Screen Shot 2017-11-21 at 1.18.09 PM.png

Thanks Ann for your response. I fear I am not seeing the server configuration option under tools as you can see in the snapshot which I have shared. The one which I have is pgadmin ver4 on windows and I believe the snapshot which you shared is based on non-Windows platform.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

783 views 33 5
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you