Re: PostgreSQL fails to start

From: Reid Thompson <reid(dot)thompson(at)ateb(dot)com>
To: John Gage <jsmgage(at)numericable(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL fails to start
Date: 2010-02-21 02:47:33
Message-ID: 4B809EC5.2000809@ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/20/2010 4:42 PM, John Gage wrote:
> I have had the same/similar problem on a Mac. Postgres creates a user
> "postgres" and the only way that user can see files is for them to exist
> outside of any other particular user's home directory. I placed the
> files in the root directory!? I would like, I think, to give "postgres"
> privileges in my home directory (emphasis, I think). As a sign of
> despicable laziness, could I ask where the granting of user privileges
> is documented in the 8.4 docs?
>
> John
>

directory/file permissions is an OS behavior, not a postgresql behavior. Since OSX is unixen, you could make
sure that you and postgres are are members of a common group. Then, you can grant whatever group privileges
you want to the files/directories that you want common access to.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Reid Thompson 2010-02-21 02:49:33 Re: PostgreSQL fails to start
Previous Message Petr Chmelar 2010-02-21 02:38:21 Asynchronous queries - processing listen (notify) in a procedural language