Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission. - Mailing list pgsql-novice

From Michael Wood
Subject Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
Date
Msg-id 5a8aa6680909010811v261b6c48y9a19aed21f871150@mail.gmail.com
Whole thread Raw
In response to Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.  (Michael Wood <esiotrot@gmail.com>)
List pgsql-novice
2009/9/1 Michael Wood <esiotrot@gmail.com>:
> 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

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@gmail.com>

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
Next
From: Adam Wałach
Date:
Subject: Variadic functions and name