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

2009/9/1 Michael Wood <esiotrot(at)gmail(dot)com>:
> 2009/8/31 nextstopsun <nextstopsun(at)gmail(dot)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

Of course, I meant /usr/local/pgsql/data/pg_hba.conf.

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

--
Michael Wood <esiotrot(at)gmail(dot)com>