Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5C5FA650F23 for ; Thu, 3 Jul 2008 13:10:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36999-03-2 for ; Thu, 3 Jul 2008 13:10:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web53708.mail.re2.yahoo.com (web53708.mail.re2.yahoo.com [206.190.37.29]) by postgresql.org (Postfix) with SMTP id 94E89650FAC for ; Thu, 3 Jul 2008 13:07:24 -0300 (ADT) Received: (qmail 43778 invoked by uid 60001); 3 Jul 2008 16:07:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID; b=bcwilWONdnOsypDPhbCjRtMVc+9DlKA+qH8IDew6eG7dvCVn12NbBTkFvKDaQW3NAxcYbV9KdHjQHqUsSNWb2GTdGi1LzxD0zIraw50gUJx6/hoitgKXTxjSXpCbg6CHnoW5ju3UUDpFB9bhpSUevkY4m5VPrxaNXOEuDVSQ2yU=; Received: from [82.182.120.68] by web53708.mail.re2.yahoo.com via HTTP; Thu, 03 Jul 2008 09:07:23 PDT X-Mailer: YahooMailWebService/0.7.199 Date: Thu, 3 Jul 2008 09:07:23 -0700 (PDT) From: Dev Reply-To: dev_hyd2001@yahoo.com Subject: Best way to limit database sizes To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-898083684-1215101243=:42270" Message-ID: <619537.42270.qm@web53708.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/42 X-Sequence-Number: 29652 --0-898083684-1215101243=:42270 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi, =A0=A0=A0=A0=A0=A0=A0 I have a single Postgres server which will be hosting= multiple databases belonging to different users. What would be the recomme= ndation to limit the size of each of the databases?=20 I've considered creating a tablespace in a directory owned by the user , so= I can use Linux quotas to prevent higher disk usage , but this turned out = be a bad thought, as all the files are anyway owned by the postgres user an= d so disk quotas won't have any effect. Now I'm contemplating having a cron job which checks the size of each table= space belonging to a user and somehow informing the admin about db's gettin= g over the threshold size. Is there anyone who has tried a better=A0 way to limit the db sizes ? cheers /Dev =0A=0A=0A --0-898083684-1215101243=:42270 Content-Type: text/html; charset=us-ascii
Hi,

        I have a single Postgres server which will be hosting multiple databases belonging to different users. What would be the recommendation to limit the size of each of the databases?

I've considered creating a tablespace in a directory owned by the user , so I can use Linux quotas to prevent higher disk usage , but this turned out be a bad thought, as all the files are anyway owned by the postgres user and so disk quotas won't have any effect.

Now I'm contemplating having a cron job which checks the size of each tablespace belonging to a user and somehow informing the admin about db's getting over the threshold size.

Is there anyone who has tried a better  way to limit the db sizes ?

cheers

/Dev

--0-898083684-1215101243=:42270--