Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 9053647611C for ; Fri, 7 Jun 2002 17:42:30 -0400 (EDT) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 9A2F84764D6 for ; Fri, 7 Jun 2002 17:41:51 -0400 (EDT) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1510070; Fri, 07 Jun 2002 14:41:52 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: =?iso-8859-1?q?Maur=EDcio=20Sessue=20Otta?= , Subject: Re: Limiting database size Date: Fri, 7 Jun 2002 14:42:36 -0700 X-Mailer: KMail [version 1.4] References: <005a01c20e57$3dbdfcc0$8359e6c8@cristorei.com.br> In-Reply-To: <005a01c20e57$3dbdfcc0$8359e6c8@cristorei.com.br> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200206071442.36850.josh@agliodbs.com> X-Archive-Number: 200206/86 X-Sequence-Number: 8051 Mauricio, > Hi, is there any way to limit the database size?? First, this is a question for PGSQL-NOVICE or PGSQL-GENERAL, not this maili= ng=20 list. Second -- sort of. You can put the database on its own hard drive partitio= n.=20=20 Then the database will crash when it runs out of space -- so I'm not sure= =20 that helps you.=20=20 Of course, with other RDBMSs, which have administrative settings for size= =20 limits, the database shuts down when you're out of space. So I'm not sure= =20 how useful the whole idea is. --=20 -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