Hi, Christoph,
On Sun, Aug 13, 2017 at 10:09 AM, Christoph Berg <myon@xxxxxxxxxx> wrote:
> Re: Igor Korot 2017-08-13 <CA+FnnTwxiLXD2H_njPS6yf=nhjaE8vcwWFdVPPzbcuADmXTHgA@xxxxxxxxxxxxxx>
>> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
