Re: limit the database size

From: Laszlo Hornyak <kocka(at)tigrasoft(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: limit the database size
Date: 2003-10-10 06:13:29
Message-ID: 3F864E09.6040500@tigrasoft.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

I believe you don`t need to recompile, just
export PGDATA=/home/me/pgdata
pg_initdb
pg_ctl start
and ready to go.

Laci

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 Oliver Elphick 2003-10-10 06:32:50 Re: limit the database size
Previous Message Alexey A. Britchko 2003-10-10 03:56:17