From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Unable to connect to 9.5 via JDBC driver 1207 |
Date: | 2016-02-02 19:16:14 |
Message-ID: | CADK3HHKQiE_Ma8D5na+qyQRrKPcHWtBrkuSxSCEcjgqXQrZCGg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On 2 February 2016 at 14:13, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> As I said: by simply switching to the previous driver, everything was fine.
>
> It works fine with JDBC connections to localhost, but not to a remote
> server (psql was fine)
>
> I had also one user of SQL Workbench/J who reported the same problem and
> after switching to 1206 the problem went away for him as well.
>
>
> Thomas
>
> Well clearly we would like to get to the root of this problem. Is it
possible for you to provide us with more information?
Dave Cramer
davec(at)postgresintl(dot)com
www.postgresintl.com
> Dave Cramer schrieb am 02.02.2016 um 19:57:
>
>> In this case there are no tcp connections allowed in pg_hba.conf.
>>
>> java by default only connects to tcp connections. psql will connect to
>> local socket in the example above
>>
>> try psql -h localhost ... to see the same results
>>
>> Dave Cramer
>>
>> davec(at)postgresintl(dot)com <mailto:davec(at)postgresintl(dot)com>
>> www.postgresintl.com <http://www.postgresintl.com>
>>
>> On 2 February 2016 at 13:54, Thomas Kellerer <spam_eater(at)gmx(dot)net <mailto:
>> spam_eater(at)gmx(dot)net>> wrote:
>>
>> rob stone schrieb am 02.02.2016 um 18:08:
>>
>> Hello,
>>
>> I downloaded the 9.5 release as Debian packages and everything is
>> working as intended except for obtaining a connection via the JDBC
>> driver.
>>
>> org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry
>> for host
>> "127.0.0.1", user "timeman", database "timemanager", SSL off
>> at
>>
>>
>> I had the same problem, I could only resolve it by switching back to
>> 1206
>>
>>
>>
>>
>>
>>
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org <mailto:
>> pgsql-jdbc(at)postgresql(dot)org>)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>>
>>
>>
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-02-02 19:38:51 | Re: Unable to connect to 9.5 via JDBC driver 1207 |
Previous Message | Thomas Kellerer | 2016-02-02 19:13:49 | Re: Unable to connect to 9.5 via JDBC driver 1207 |