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
>
>
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 |