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 <ikoro...@gmail.com> 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
