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.