From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: limit the database size |
Date: | 2003-10-10 15:24:33 |
Message-ID: | Pine.LNX.4.33.0310100923530.18902-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
There's also the initlocation $ENVAR solution:
http://www.postgresql.org/docs/7.3/static/manage-ag-alternate-locs.html
On Fri, 10 Oct 2003, Rudi Starcevic wrote:
> Hi Wim,
>
> It is possible to compile PostgreSQL so that it can keep each users
> database in their home dir. ( or another dir. of your choice. )
> Then you can put a quota on the user's home dir.
>
> To do this the only way I know is to compile from source.
> It was about 2 years ago I did this last so I've forgetten the compile
> flags which you need
> to pass in to 'configure' or 'make'.
>
> You'll need to search the online installation docs or perhaps someone on
> this list can point
> out the required C flags.
>
> I found this method works very well.
> For Mysql we had to write scripts which regularly checked quota's and
> disk size which was
> no where need as elegent at PostgreSQL.
>
> Hope this helps
> Cheers
> Rudi.
>
> Wim Bertels wrote:
>
> > Ola,
> >
> > is it possible to limit the database size,
> > ie like for example i create a database and then limit somehow the
> > maximum database size.
> >
> > scripts for arranging this?
> >
> > tnx,
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rudi Starcevic | 2003-10-10 15:30:16 | Re: limit the database size |
Previous Message | Robert Treat | 2003-10-10 15:06:19 | Re: Oracle takes the wraps off SME database |