Graham Leggett wrote:
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
Aha! there it is. Adding a user to a group doesn't mean anything until
that user reinitializes the environment. That is why restarting
postgresql resolves the issue. When postgresql is started, is actually
launches a new shell as the user and the fact that they are part of the
group is picked up.
Sincerely,
Joshua D. Drake
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin