Re: [GENERAL] 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@debian.org> wrote:
> Re: Igor Korot 2017-08-13 <CA+FnnTz8h-2tkRMv4uYN-fkRFU601cws9-uS7vwfpr-fka0edg@mail.gmail.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