On 12/28/2016 11:55 AM, Rich Shepard wrote:
On Wed, 28 Dec 2016, John R Pierce wrote:
with psql, no -h and -h localhost are two different connection types. if
you don't specify a -h, it uses a 'unix domain socket',
Thanks, John. I believe that I understand the differences. Here,
/var/lib/pgsql/9.6/data/pg_hba.conf contains:
# IPv4 local connections:
host all rshepard 192.168.55.0/24 trust
hostnossl all rshepard 192.168.55.0/24 trust
I would never 'trust' a whole LAN subnet, I generally use md5 password authentication over a LAN. if these java processes are running on the same host as the database server, you probably want to allow connections from localhost (127.0.0.1 and ::1), frankly, I usually don't even like to use 'trust' on localhost.
--
john r pierce, recycling bits in santa cruz