Re: JDBC Connection Errors - Mailing list pgsql-general

From Sam Nelson
Subject Re: JDBC Connection Errors
Date
Msg-id CAD+BJxLT7HjLR2yByDFMQxL9v8fkhxa1B3oZhfqsck74dYDAJw@mail.gmail.com
Whole thread Raw
In response to Re: JDBC Connection Errors  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Everything is remote.  I thought of the IPv6 thing, but that seems
unlikely - all connections are coming from the same system.

Still, we'll ask them and try to get some more details about things like that.
---
===========================
Samuel Nelson
Consistent State
www.consistentstate.com
303-955-0509
===========================



On Tue, Aug 23, 2011 at 5:46 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> On Tuesday, August 23, 2011 3:47:33 pm 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.
>
> Are PgAdmin and psql local and the Java client remote?
> Is the Java client connecting using IPv6 ?
>
>> -I can find no errors in the log file from that day for the user that
>> the client is trying to log in as.
>>
>> We're working on getting access to more details about how they're
>> trying to connect, but in the mean time, does anyone know if JDBC has
>> any issues connecting that psql and PGAdmin wouldn't have?  Is it
>> possible that JDBC is somehow susceptible to connection issues that
>> JDBC and psql are not?
>> ---
>> ===========================
>> Samuel Nelson
>> Consistent State
>> www.consistentstate.com
>> 303-955-0509
>> ===========================
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: JDBC Connection Errors
Next
From: Royce Ausburn
Date:
Subject: Re: Collapsing multiple subqueries into one