* Rod Taylor (pg@rbt.ca) wrote:
> > > Group quotas should be sufficient. Create directory readable/writable to
> > > only the pgsql user, but have the group ownership be representative of
> > > the user in question.
> >
> > Rather ugly, and you'll run out of groups if you have alot of users (the
> > postgres user can only be in so many groups). It's a cute idea but I
> > really don't see it as being viable.
>
> The postgres user doesn't need to be in any of the groups, the group
> simply exists simply to give the directory representation for a quota.
I'm not sure if this would really work... Are you sure the quota would
be enforced against a user not in the group? Of course, I still see it
as very ugly and a workaround at best...
Stephen
