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>