My understanding is databases reside within 'database clusters' in postgresql. Is this right? Can I run multiple database clusters within one postgresql/postmaster server? Then could I use filesystem quotas for each cluster? Thank you! -----Original Message----- From: Joshua D. Drake [mailto:jd@commandprompt.com] Sent: Thursday, May 27, 2004 2:12 PM To: Campano, Troy Cc: Postgres general mailing list Subject: Re: Database Size Limiting Hello, You could use Filsystem quotas but I strongly suggest against it as it will probably bring about database corruption. A better solution would be to monitor the space being allocated so you can add storage as required. Sincerely, Joshua D. Drake Campano, Troy wrote: > --> > > 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* > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
