Re: limit the database size

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

In response to

Responses

Browse pgsql-admin by date

  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