Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 61D0847694E for ; Tue, 25 Jun 2002 16:48:09 -0400 (EDT) Mailbox-Line: From emayo@pozicom.net Tue Jun 25 16:48:09 2002 Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 96065475C7F for ; Tue, 25 Jun 2002 15:48:57 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 2F754381927; Tue, 25 Jun 2002 15:48:10 -0400 (EDT) From: "Eric" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Limiting database size Date: Tue, 25 Jun 2002 15:48:10 -0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 41 Message-ID: References: <200206071442.36850.josh@agliodbs.com> X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-sql@postgresql.org X-Spam-Status: No, hits=1.0 required=5.0 tests=FROM_NAME_NO_SPACES,DOUBLE_CAPSWORD version=2.30 X-Spam-Level: * X-Archive-Number: 200206/346 X-Sequence-Number: 8311 I like the idea of putting it on a hard disk or partition of fixed size and waiting for the DB to simply crash. hahaha "Josh Berkus" wrote in message news:200206071442.36850.josh@agliodbs.com... > Mauricio, > > > Hi, is there any way to limit the database size?? > > First, this is a question for PGSQL-NOVICE or PGSQL-GENERAL, not this mailing > list. > > Second -- sort of. You can put the database on its own hard drive partition. > Then the database will crash when it runs out of space -- so I'm not sure > that helps you. > > Of course, with other RDBMSs, which have administrative settings for size > limits, the database shuts down when you're out of space. So I'm not sure > how useful the whole idea is. > > -- > -Josh Berkus > > ______AGLIO DATABASE SOLUTIONS___________________________ > Josh Berkus > Complete information technology josh@agliodbs.com > and data management solutions (415) 565-7293 > for law firms, small businesses fax 621-2533 > and non-profit organizations. San Francisco > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >