Re: Where is pg_hba.conf

Hi,
OK, I found it under the root account.

Now I am modifying it as follows:

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 192.168.1.3/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres md5
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5

Should "METHOD" column be lept as 'md5' or as 'trusted' as in the link
I posted in the OP?

Thank you.

On Sun, Aug 13, 2017 at 10:37 AM, Christoph Berg <myon(at)debian(dot)org> wrote:
> Re: Igor Korot 2017-08-13 <CA+FnnTz8h-2tkRMv4uYN-fkRFU601cws9-uS7vwfpr-fka0edg(at)mail(dot)gmail(dot)com>
>> draft=# SHOW hba_file
>> draft-# SHOW hba_file;
>> ERROR: syntax error at or near "SHOW"
>> LINE 2: SHOW hba_file;
>> ^
>
> Standard beginners error. If you forgot the ";" on the first line,
> it'll process both lines as a single, erroneous command. Note the
> "-#" prompt.
>
> If you run into that situation again, hit ^C.
>
> Christoph