Re: Best way to limit database sizes

--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 ****t numbers for each user/group ?

/Dev


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

>>> Dev <dev_hyd2001@[EMAIL PROTECTED]
> 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 ****t numbers for each
user/group ?<br><br>/Dev<br><br><br>--- On <b>Thu, 7/3/08, Kevin Grittner
<i>&lt;Kevin.Grittner@[EMAIL PROTECTED]
></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@[EMAIL PROTECTED]
>Subject: Re: [ADMIN] Best way to
limit database sizes<br>To: pgsql-admin@[EMAIL PROTECTED]
>Date: Thursday, July 3, 2008, 6:28
PM<br><br><pre>&gt;&gt;&gt; Dev &lt;dev_hyd2001@[EMAIL PROTECTED]
 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--