Postgres Pro
Downloads
Home   >   mailing lists

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

From armand pirvu
Subject Re: [GENERAL] Where is pg_hba.conf
Date
Msg-id D9CE6DB0-42B3-4C17-8717-2DE2E58F2E7E@gmail.com
Whole thread Raw
In response to [GENERAL] Where is pg_hba.conf  (Igor Korot <ikorot01@gmail.com>)
Responses Re: [GENERAL] Where is pg_hba.conf  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Tree view
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@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

pgsql-general by date:

Previous
From: Christoph Berg
Date:
Subject: Re: [GENERAL] Where is pg_hba.conf
Next
From: Igor Korot
Date:
Subject: Re: [GENERAL] Where is pg_hba.conf