Re: Could not create a tablespace - permission denied

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
--