Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id AEEAA650E8F
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 14:48:14 -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 29206-01 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu,  3 Jul 2008 14:48:02 -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 AAE37650E87
	for <pgsql-admin@postgresql.org>; Thu,  3 Jul 2008 14:48:03 -0300 (ADT)
Received: (qmail 21236 invoked by uid 60001); 3 Jul 2008 17:48:01 -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:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=G0WBEzopDOCbtV5Oa2bWPvoXAELcpUiLGQyQrtZLyaCAx3bHxlMQmK+E7fPQ8jOHu2sAC/d5Ae8bHtwoph9IMx3y1Uq7k9suR/2WnkmU2bCixY5DuYQGLDHcQ1QzZr58SRIEH6oufDUF2C88JjRow38gpOmXGS7/1nW9QRSu5Yg=;
Received: from [83.249.198.89] by web53708.mail.re2.yahoo.com via HTTP;
	Thu, 03 Jul 2008 10:48:01 PDT
X-Mailer: YahooMailWebService/0.7.199
Date: Thu, 3 Jul 2008 10:48:01 -0700 (PDT)
From: Dev <dev_hyd2001@yahoo.com>
Reply-To: dev_hyd2001@yahoo.com
Subject: Re: Best way to limit database sizes
To: pgsql-admin@postgresql.org
In-Reply-To: <486CB7E4.EE98.0025.0@wicourts.gov>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1889021544-1215107281=:20954"
Message-ID: <869366.20954.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/44
X-Sequence-Number: 29654

--0-1889021544-1215107281=:20954
Content-Type: text/plain; charset=us-ascii

yes, thats an option but currently the last resort! Doesn't it get difficult to manage so many instances of servers ? Also don't we then need to keep track of different port numbers for each user/group ?

/Dev


--- On Thu, 7/3/08, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Subject: Re: [ADMIN] Best way to limit database sizes
To: pgsql-admin@postgresql.org, dev_hyd2001@yahoo.com
Date: Thursday, July 3, 2008, 6:28 PM

>>> Dev <dev_hyd2001@yahoo.com> wrote: 
>         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? 
 
Have you considered running a different cluster for each user?
Each should be run with a different OS user ID, and it would be
pretty easy to limit the size of each.
 
-Kevin


      
--0-1889021544-1215107281=:20954
Content-Type: text/html; charset=us-ascii

<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top' style='font: inherit;'>yes, thats an option but currently the last resort! Doesn't it get difficult to manage so many instances of servers ? Also don't we then need to keep track of different port numbers for each user/group ?<br><br>/Dev<br><br><br>--- On <b>Thu, 7/3/08, Kevin Grittner <i>&lt;Kevin.Grittner@wicourts.gov&gt;</i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Kevin Grittner &lt;Kevin.Grittner@wicourts.gov&gt;<br>Subject: Re: [ADMIN] Best way to limit database sizes<br>To: pgsql-admin@postgresql.org, dev_hyd2001@yahoo.com<br>Date: Thursday, July 3, 2008, 6:28 PM<br><br><pre>&gt;&gt;&gt; Dev &lt;dev_hyd2001@yahoo.com&gt; wrote: <br>&gt;         I have a single Postgres server which will be hosting<br>multiple <br>&gt; databases belonging to different users. What would be the<br>recommendation to
 <br>&gt; limit the size of each of the databases? <br> <br>Have you considered running a different cluster for each user?<br>Each should be run with a different OS user ID, and it would be<br>pretty easy to limit the size of each.<br> <br>-Kevin</pre></blockquote></td></tr></table><br>



      
--0-1889021544-1215107281=:20954--