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
begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0034 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
