Re: Unable to connect to 9.5 via JDBC driver 1207 - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: Unable to connect to 9.5 via JDBC driver 1207
Date
Msg-id n8qv5f$mcf$1@ger.gmane.org
Whole thread Raw
In response to Re: Unable to connect to 9.5 via JDBC driver 1207  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Unable to connect to 9.5 via JDBC driver 1207
List pgsql-jdbc
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


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@postgresintl.com <mailto:davec@postgresintl.com>
> www.postgresintl.com <http://www.postgresintl.com>
>
> On 2 February 2016 at 13:54, Thomas Kellerer <spam_eater@gmx.net <mailto:spam_eater@gmx.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@postgresql.org <mailto:pgsql-jdbc@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-jdbc
>
>


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Unable to connect to 9.5 via JDBC driver 1207
Next
From: Dave Cramer
Date:
Subject: Re: Unable to connect to 9.5 via JDBC driver 1207