Re: Could not create a tablespace - permission denied - Mailing list pgsql-admin

From Graham Leggett
Subject Re: Could not create a tablespace - permission denied
Date
Msg-id 480A381D.3030908@sharp.fm
Whole thread Raw
In response to Re: Could not create a tablespace - permission denied  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Could not create a tablespace - permission denied
List pgsql-admin
Joshua D. Drake wrote:

> I am pretty sure you are missing something. I can not reproduce your issue:

Do it like this:

- mkdir /tmp/foo
- chown user:user /tmp/foo
- edit /etc/group and add postgres to the group user
- attempt to access /tmp/foo as the user postgres, at this point a user
logged in as postgres will be able to access the directory.
- attempt to create a tablespace on /tmp/foo, this will fail until
postgresql is restarted, after which the attempt will succeed.

Regards,
Graham
--

Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Could not create a tablespace - permission denied
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Could not create a tablespace - permission denied