Re: Where is pg_hba.conf

[armand pirvu <armand.pirvu@xxxxxxxxx>]

Normally should reside in the data dir. My case below

armandps-MacBook-Air:~ armandp$ ps -fu postgres |grep data

  502 29591     1   0 Thu09PM ??         0:01.63 /Library/PostgreSQL/9.6/bin/postgres -D /Library/PostgreSQL/9.6/data

armandps-MacBook-Air:~ armandp$ ls -l /Library/PostgreSQL/9.6/data/pg_hba.conf

ls: /Library/PostgreSQL/9.6/data/pg_hba.conf: Permission denied

armandps-MacBook-Air:~ armandp$ sudo ls -l /Library/PostgreSQL/9.6/data/pg_hba.conf

-rw-------  1 postgres  daemon  4248 Aug 10 21:17 /Library/PostgreSQL/9.6/data/pg_hba.conf

Is it possible that global search fails from a permission error ?

Hope this helps

On Aug 13, 2017, at 9:00 AM, Igor Korot <ikorot01@xxxxxxxxx> wrote:

Hi,
I have a Mac with OSX 10.8 installed. It has Postgre 9.1.
According to https://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html
and http://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/?utm_source=tuicool
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.
I am able to connec to the server locally with psql. I can also
connect to the server
from the ODBC driver from my program. However doing a global search I
can't find that file.

Can someone please help?

Thank you.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general