Re: [GENERAL] Database Size Limiting

[Ben-Nes Michael]

Title: Database Size Limiting

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 ----- From: Campano, Troy To: Postgres general mailing list 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