| 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 15:31:31 |
| Message-ID: | 20040709153131.GG21419@ns.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
* Rod Taylor (pg(at)rbt(dot)ca) wrote:
> > > > Since the user accessing/writing to the tablespaces would be the
> > > > postgres user I don't really think this 'solution' works in reality.
> > >
> > > I had assumed it would be a directory based quota rather than a user
> > > based one.
> >
> > It's been a while since I played with quotas but I don't recall this
> > option being available.
>
> 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.
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-07-09 15:35:52 | Re: User Quota Implementation |
| Previous Message | Rod Taylor | 2004-07-09 15:25:15 | Re: User Quota Implementation |