"Joshua D. Drake" <jd@commandprompt.com> writes:
> Graham Leggett wrote:
>> - 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.
In particular, it looks like the list of groups you belong to is
typically only computed at login time (or equivalently su -l, which
is what's happening in the postgres init script), and then just
inherited by all processes launched from that login. So there is
caching of a sort going on here, but it's in the kernel and there's
nothing we can do about it.
regards, tom lane
