Hi, armand, On Sun, Aug 13, 2017 at 10:12 AM, armand pirvu <armand.pi...@gmail.com> wrote: > 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 ?
MyMac:/ igorkorot$ ps -fu postgres |grep data 502 77 1 0 11:38PM ?? 0:00.45 /Library/PostgreSQL/9.1/bin/postmaster -D/Library/PostgreSQL/9.1/data 502 1733 243 0 10:42AM ?? 0:00.05 /System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Versions/A/Support/mdworker -s mdworker -c MDSImporterWorker -m com.apple.mdworker.shared MyMac:/ igorkorot$ ls -la /Library/PostgreSQL/9.1/data/ ls: : Permission denied MyMac:/ igorkorot$ su Password: sh-3.2# ls -la /Library/PostgreSQL/9.1/data/ total 88 drwx------ 20 postgres daemon 680 Aug 12 23:38 . drwxr-xr-x 16 root daemon 544 Dec 4 2016 .. -rw------- 1 postgres daemon 4 Dec 4 2016 PG_VERSION drwx------ 7 postgres daemon 238 Dec 9 2016 base drwx------ 42 postgres daemon 1428 Aug 12 23:39 global drwx------ 3 postgres daemon 102 Dec 4 2016 pg_clog -rw------- 1 postgres daemon 4222 Dec 4 2016 pg_hba.conf -rw------- 1 postgres daemon 1636 Dec 4 2016 pg_ident.conf drwxr-xr-x 204 postgres daemon 6936 Aug 13 00:00 pg_log drwx------ 4 postgres daemon 136 Dec 4 2016 pg_multixact drwx------ 3 postgres daemon 102 Aug 12 23:38 pg_notify drwx------ 2 postgres daemon 68 Dec 4 2016 pg_serial drwx------ 3 postgres daemon 102 Aug 13 10:43 pg_stat_tmp drwx------ 3 postgres daemon 102 Dec 4 2016 pg_subtrans drwx------ 2 postgres daemon 68 Dec 4 2016 pg_tblspc drwx------ 2 postgres daemon 68 Dec 4 2016 pg_twophase drwx------ 5 postgres daemon 170 Dec 11 2016 pg_xlog -rw-r--r-- 1 postgres daemon 19162 Dec 4 2016 postgresql.conf -rw------- 1 postgres daemon 70 Aug 12 23:38 postmaster.opts -rw------- 1 postgres daemon 75 Aug 12 23:38 postmaster.pid sh-3.2# Apparently it looks like the failure is from the permission. So how do I enable it? Or it has to stay for "root" only? Thank you. > > 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 > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
