Re: max connections - Mailing list pgsql-general

From Richard Huxton
Subject Re: max connections
Date
Msg-id 200302211050.18447.dev@archonet.com
Whole thread Raw
In response to Re: max connections  (Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>)
List pgsql-general
On Thursday 20 Feb 2003 5:31 pm, Thomas Beutin wrote:
> On Thu, Feb 20, 2003 at 04:17:33PM +0100, Jose Antonio Martinez wrote:
> > how can i limit the number of concurrent connections
> > to the same database at a postgresql server  (wich
> > have several databases)?
> >
> > is there any easy way?
>
> command line: "-N x"
> config file: "max_connections = x"
>
> It's all explained in the very good documentation.

I think Jose wanted to restrict access such as:

# this exists
max_connections = 32
# these don't
max_connections.db1 = 20
max_connections.db2 = 15

which I don't think you can do at the database level - it'll have to be
something you do at the application level I believe.

--
  Richard Huxton

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Problem with aliasing
Next
From: Richard Huxton
Date:
Subject: Re: cursors and column names