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

2009/8/31 nextstopsun <nextstopsun@gmail.com>:
[...]
> 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
> -------------

What does this give you:

$ ls -ld /usr/local/pgsql/data/

Also:

$ ls -l /usr/local/pgsql/data/pg_hbs.conf

Maybe the postgres user is not the owner of that directory.

--
Michael Wood <esiotrot@gmail.com>