Re: Database Size Limiting - Mailing list pgsql-general

From Ben-Nes Michael
Subject Re: Database Size Limiting
Date
Msg-id 005801c44482$b3ef7af0$0a00a8c0@mikislap
Whole thread Raw
In response to Database Size Limiting  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List pgsql-general
I wonder if this will work:
 
each DB should assigned a diffrent user with set of premissions ( including insert ).
 
a script that can revoke the inseret privilage will emarge from time to time to check the DB size.
 
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
----- Original Message -----
Sent: Thursday, May 27, 2004 8:07 PM
Subject: [GENERAL] Database Size Limiting

Is there a way to limit the size that an individual database can take up?

My understanding is that all your databases go into a file system which is your ‘catalog cluster’.

But all the databases can grow until that filesystem is full.

Is there a way to limit how big a database can be? Can you allocated space when the database is set up so you can say db1 can only be 100 MB?

 

Thank you!

Troy Campano

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: query results different after vacuum analyze? 7.4.0
Next
From: Richard Huxton
Date:
Subject: Re: Database Size Limiting