Re: wish: limit number of connections per database - Mailing list pgsql-hackers

From Oliver Elphick
Subject Re: wish: limit number of connections per database
Date
Msg-id 1063230273.21803.131.camel@linda.lfix.co.uk
Whole thread Raw
In response to wish: limit number of connections per database  ("bognár, attila" <attila.bognar@netalfa.com>)
List pgsql-hackers
On Wed, 2003-09-10 at 20:22, "bognár, attila" wrote:

> Would it be possible to set the maximum number of connections to each
> database individually? I need this because the server will be shared
> between several users and I want to avoid that that somebody uses the
> maximum number of connections possible to the server, locking out others.

I assume users shouldn't be allowed to use other users' databases?

If so, why not have a separate postmaster (and a separate database
cluster) for each user?  Each one would connect on a different port, and
each one could be separately configured.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "Draw near to God and he will draw near to you.       Cleanse your hands,
yousinners; and purify your       hearts, you double minded."       James 4:8  



pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: massive quotes?
Next
From: "Darko Prenosil"
Date:
Subject: Re: Trouble with error message encoding