Re: Unable to connect to 9.5 via JDBC driver 1207

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

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc