Re: Questions on use

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Questions on use
Date: 2016-12-28 16:44:30
Message-ID: alpine.LNX.2.11.1612280841430.30065@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Wed, 28 Dec 2016, David G. Johnston wrote:

> Should work. The 9.4 doesn't imply server compatability.

David,

Good. That's one less issue of concern.

> The default for PostgreSQL is to listen on Unix sockets. JDBC doesn't
> talk to Unix sockets - it only uses TCP/IP sockets. You need to configure
> the database to listen on an IP address and port and point to that. You
> also need to ensure pg_hba.conf and/or have a password on the user JDBC is
> using (changing to "trust" might work).

I modified /var/lib/pgsql/9.6/data/pg_hba.conf by adding a line with
hostnossl and 'trust' as the method. Reloaded postgres. While schemaSpy
still does not run the reason seems to be with it, not the driver.

Many thanks,

Rich

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message John R Pierce 2016-12-28 18:18:38 Re: Questions on use
Previous Message David G. Johnston 2016-12-28 16:10:12 Re: Questions on use