Re: Where is pg_hba.conf

Also, I presume that the address in this file is the address of the
machine where the server is located, not the address from where the
connection is initiated.

On Sun, Aug 13, 2017 at 10:53 AM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> 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