Re: Questions on use

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