Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

From: nextstopsun <nextstopsun(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
Date: 2009-08-31 09:46:23
Message-ID: 25220784.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello.
I’m having a problem starting server on mac os x.

-------------
bash-3.2$ /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data
server starting
bash-3.2$ LOG: could not open configuration file
"/usr/local/pgsql/data/pg_hba.conf": Permission denied
FATAL: could not load pg_hba.conf
-------------

The problem appears after changing permissions for /data folder in finder. I
did this:

I’m installing postgresql 8.4 from MacOS binary and it installs and starts
ok. Then I try to edit pg_hba.conf in pgAdmin3 to add a line
--------------
host all all 10.0.0.6 md5
--------------
After I click save icon to save a file it doesn’t save – probably it doesn’t
have enough permission for that. So I go to my /usr/local/pgsql/data/ folder
in Finder – unlock it’s permissions and set read/write to everyone group.
Then I edit the pg_hba file with TextEdit.app and it looks like this

-------------
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 10.0.0.6 md5
# IPv6 local connections:
host all all ::1/128 trust
-------------

Then server doesn’t start – start server.app exits with non-zero value.
Command line returns
-------------
BigMac:~ postgres$ FATAL: data directory "/usr/local/pgsql/data" has group
or world access
DETAIL: Permissions should be u=rwx (0700).

chmod 700 /usr/local/pgsql/data/
BigMac:~ postgres$ /usr/local/pgsql/bin/pg_ctl start -D
/usr/local/pgsql/data

server starting
BigMac:~ postgres$ LOG: could not open configuration file
"/usr/local/pgsql/data/pg_hba.conf": Permission denied
FATAL: could not load pg_hba.conf
-------------

I’ve tried installing postgre from source thru fink, and the problem stays
the same. I’m really stuck here, and I really need postgre to be accessed
from 10.0.0.6 machine.
What am I doing wrong? As I understand it’s a folder access permission
problem, but I don’t know how to fix it. Can anyone PLEASE help me?

--
View this message in context: http://www.nabble.com/Problem-starting-pgsql-server-on-Mac-OS-X.-Pg_hba.conf-reading-permission.-tp25220784p25220784.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jason K. Ergle 2009-08-31 14:54:58 Postgresql.conf getting corrupted
Previous Message Guillaume Lelarge 2009-08-30 16:22:20 Re: [ADMIN] Background color in query tool