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

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.