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.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
