Confluence PostgreSQL JDBC direct connection refused
Platform Notice: Server and Data Center Only. This article only applies to Atlassian products on the server and data center platforms.
The following appears in the
atlassian-confluence.log file, indicating a connection refused when using Confluence with JDBC direct connection string:
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
- PostgreSQL database
Here are some quick and handy diagnostic scripts:
ps -f -u postgres
This should list the PostgreSQL processes in your environment:
sudo lsof -n -u postgres |grep LISTEN or sudo netstat -ltnp | grep postgres
This will show the TCP/IP addresses and ports that your instance of PostgreSQL is listening upon.
This is a configuration issue with PostgreSQL, not Confluence. The root cause is that the PostgreSQL
pga_hba.conf file is not set to TRUST versus IDENT as usually found under:
and shown herein below:
# TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: host all all 127.0.0.1/32 ident host all all 100.200.300.50/32 ident # IPv6 local connections: host all all ::1/128 ident
IP address range 100.200.300.50/32 is only used herein for purposes of example, please do not use that address.
- Open the file
/var/lib/psql/pg_hba.confin your favorite text editor of choice with appropriate permissions
- You may have to use sudo to obtain the correct permissions to edit and save the file as needed
Edit the file, altering the values written as IDENT above to TRUST as shown below
# TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 100.200.300.50/32 trust # IPv6 local connections: host all all ::1/128 ident