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