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