Re: JDBC Connection Errors - Mailing list pgsql-general

From Craig Ringer
Subject Re: JDBC Connection Errors
Date
Msg-id 4E5A43A6.3010909@ringerc.id.au
Whole thread Raw
In response to JDBC Connection Errors  (Sam Nelson <samn@consistentstate.com>)
Responses Re: JDBC Connection Errors  (Ian Pilcher <arequipeno@gmail.com>)
List pgsql-general
On 24/08/2011 6:47 AM, Sam Nelson wrote:
> Hi list,
>
> A client is hitting an issue with JDBC:
> org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting
> TCP/IP connections.
>
> -pg_hba.conf is set to trust 0.0.0.0/0 (IPv4 only)
> -listen_addresses is *
> -I can find no evidence of iptables running on the server.
> -PGAdmin connects just fine.
> -psql connects just fine.
> -I can find no errors in the log file from that day for the user that
> the client is trying to log in as.
Get them to run Wireshark and capture the connection attempt, then send
you the pcap log. That should give you more information about what's
actually happening.

Check for possible SELinux involvement if the Java client is on Linux.

--
Craig Ringer

pgsql-general by date:

Previous
From: pasman pasmański
Date:
Subject: Re: Feature request: per user connections limit
Next
From: Ian Pilcher
Date:
Subject: Re: JDBC Connection Errors