Re: Database Size Limiting
| От | Ben-Nes Michael |
|---|---|
| Тема | Re: Database Size Limiting |
| Дата | |
| Msg-id | 005801c44482$b3ef7af0$0a00a8c0@mikislap обсуждение исходный текст |
| Ответ на | Database Size Limiting ("Campano, Troy" <Troy.Campano@LibertyMutual.com>) |
| Список | 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
--------------------------
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 -----From: Campano, TroySent: Thursday, May 27, 2004 8:07 PMSubject: [GENERAL] Database Size LimitingIs 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?
Troy Campano
В списке pgsql-general по дате отправления: