Re: Ownership/Permissions Problem - Mailing list pgsql-general

On Fri, 2010-12-24 at 14:09 -0800, Rich Shepard wrote:
> On Fri, 24 Dec 2010, John R Pierce wrote:
>
> > I'd check the permisisons on /usr/local/pgsql  and /usr/local/pgsql/lib too.
> > if that directory is not o+r, you'll have problems too.
>
> John,
>
>    Bingo! The subdirectories in /usr/local/pgsql were 700. Changing them to
> 755 fixed everything.
>

You will want to make sure you didn't do that
to /usr/local/pgsql/data . /usr/local/pgsql/data should be 700.

JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt