Re: Questions on use

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