Re: limit the database size

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@postgresql.org)
>