Re: Where is pg_hba.conf

Hi, Christoph,

On Sun, Aug 13, 2017 at 10:09 AM, Christoph Berg <myon(at)debian(dot)org> wrote:
> Re: Igor Korot 2017-08-13 <CA+FnnTwxiLXD2H_njPS6yf=nhjaE8vcwWFdVPPzbcuADmXTHgA(at)mail(dot)gmail(dot)com>
>> I need to modify the pg_hba.conf file to get access to the DB
>> remotely.
>>
>> However, I can't find this file anywhere on the system.
>
> Try "SHOW hba_file;".

Last login: Sat Aug 12 23:49:33 on ttys000
/Library/PostgreSQL/9.1/scripts/runpsql.sh; exit
MyMac:~ igorkorot$ /Library/PostgreSQL/9.1/scripts/runpsql.sh; exit
Server [localhost]:
Database [postgres]: draft
Port [5432]:
Username [postgres]:
Password for user postgres:
psql (9.1.24)
Type "help" for help.

draft=# SHOW hba_file
draft-# SHOW hba_file;
ERROR: syntax error at or near "SHOW"
LINE 2: SHOW hba_file;
^

Thank you.

>
> Christoph