Re: Unable to connect to 9.5 via JDBC driver 1207

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Unable to connect to 9.5 via JDBC driver 1207
Date: 2016-02-02 19:13:49
Message-ID: n8qv5f$mcf$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2016-02-02 19:16:14 Re: Unable to connect to 9.5 via JDBC driver 1207
Previous Message Dave Cramer 2016-02-02 18:57:10 Re: Unable to connect to 9.5 via JDBC driver 1207