Re: User Quota Implementation

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, "Jonah H(dot) Harris" <jharris(at)tvi(dot)edu>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: User Quota Implementation
Date: 2004-07-09 16:44:39
Message-ID: 20040709164439.GI21419@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Rod Taylor (pg(at)rbt(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2004-07-09 16:45:50 Re: User Quota Implementation
Previous Message Alvaro Herrera 2004-07-09 16:36:16 Re: User Quota Implementation