Skip site navigation (1) Skip section navigation (2)

Re: Database Size Limiting

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>,"Postgres general mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database Size Limiting
Date: 2004-05-28 07:09:22
Message-ID: 005801c44482$b3ef7af0$0a00a8c0@mikislap (view raw or flat)
Thread:
Lists: pgsql-general
Database Size LimitingI 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

In response to

pgsql-general by date

Next:From: Richard HuxtonDate: 2004-05-28 08:05:52
Subject: Re: Database Size Limiting
Previous:From: Tom LaneDate: 2004-05-28 05:35:11
Subject: Re: query results different after vacuum analyze? 7.4.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group