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

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?


 

Hello,
--------------

host    all         all         10.0.0.6              md5

You have to add mask to the ip. like,

host    all         all         10.0.0.6/32              md5

-- 
Regards,
Sachin Srivastava
www.enterprisedb.com

On Aug 31, 2009, at 5:24 AM, NNL wrote:

> 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


Most likely because the user you are using (appears to be postgres
from the prompt) is not the owner of file (and database). This would
be the case if initdb was run as a different user than postgres. Run
"ls -al" to check.  So your options are to change the ownership of the
files, or run as the user which already owns them. Something like

sudo -u username /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/
data




John DeSoi, Ph.D.