Re: [GENERAL] Where is pg_hba.conf
| От | armand pirvu |
|---|---|
| Тема | Re: [GENERAL] Where is pg_hba.conf |
| Дата | |
| Msg-id | D9CE6DB0-42B3-4C17-8717-2DE2E58F2E7E@gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] Where is pg_hba.conf (Igor Korot <ikorot01@gmail.com>) |
| Ответы |
Re: [GENERAL] Where is pg_hba.conf
|
| Список | pgsql-general |
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 по дате отправления: