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
>>> Dev <[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?
E
: Kevin Grittner <[EMAIL PROTECTED]>
Subject: Re: [ADMIN] Best way to limit database sizes
To: pgsql-admin@postgresql.org, [EMAIL PROTECTED]
Date: Thursday, July 3, 2008, 6:28 PM
>>> Dev <[EMAIL PROTECTED]> wrote:
> I have a single Postgres server which will be ho
;[EMAIL PROTECTED]>* wrote:
>
> From: Kevin Grittner <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] Best way to limit database sizes
> To: pgsql-admin@postgresql.org, [EMAIL PROTECTED]
> Date: Thursday, July 3, 2008, 6:28 PM
>
> >>> Dev <[EMAIL PROTECTED]
>>> Dev <[EMAIL PROTECTED]> wrote:
> --- On Thu, 7/3/08, Kevin Grittner <[EMAIL PROTECTED]>
wrote:
>> Have you considered running a different cluster for each user?
> Doesn't it get difficult to manage so many instances of servers ?
We haven't found it to be so. xargs is your friend, fed by fi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Le 3 juil. 08 à 18:07, Dev a écrit :
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
b
On Thu, Jul 03, 2008 at 09:10:47PM +0200, Dimitri Fontaine wrote:
> >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 postg
rze <[EMAIL PROTECTED]>
Subject: Re: [ADMIN] Best way to limit database sizes
To: pgsql-admin@postgresql.org
Date: Thursday, July 3, 2008, 9:17 PM
On Thu, Jul 03, 2008 at 09:10:47PM +0200, Dimitri Fontaine wrote:
> >I've considered creating a tablespace in a directory owned by