Re: [GENERAL] Where is pg_hba.conf - Mailing list pgsql-general

Hi, Christoph,

On Sun, Aug 13, 2017 at 10:09 AM, Christoph Berg <myon@debian.org> wrote:
> Re: Igor Korot 2017-08-13 <CA+FnnTwxiLXD2H_njPS6yf=nhjaE8vcwWFdVPPzbcuADmXTHgA@mail.gmail.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