postgresql setup connection error

[Mike Gehl]

Getting error on setup:

db url: jdbc:postgresql://localhost:5432/confluence

Can't reach database server or port

SQLState - 08001
org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

I'm able to connect to db from linux command line.

$psql -U confluenceuser -p 5432 confluence

pg_hba.conf

#local all postgres peer
local all all md5

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.0.25/24 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5

[Mike Gehl · Accepted solution]

problem was in postgresql.conf. "md5" was OK. Did not need "trust" in pg_hba.conf.

I had...

listen_addresses = '::'

Now have...

listen_addresses = 'localhost' 

All ok now. Thanks.

[AnnWorley]

Thank you for following up to let the Community know the resolution.

[adam_zhou_vanguard_com_cn]

we use Azure postgres paas service , it seemed they can't change the settings for us. we don't want to change the database, any other workaround ?

[AnnWorley]

Hi Mike,

My theory is the authentication method has to be trust instead of md5. There are sample pg_hba.conf file entries in this article: Confluence PostgreSQL JDBC direct connection refused

I look forward to hearing whether the setup wizard can be completed with the PostgreSQL configuration recommended in the article.

Thanks,

Ann