max connections

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.

So long,
-tb
--
Thomas Beutin tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

Is that per DB though? I thought that was the max connections period..

Travis

-----Original Message-----
From: Thomas Beutin [mailto:tyrone@laokoon.IN-Berlin.DE]
Sent: Thursday, February 20, 2003 11:31 AM
To: Jose Antonio Martinez
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] max connections

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.

So long,
-tb
--
Thomas Beutin tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

On Thu, Feb 20, 2003 at 06:56:52PM +0100, Jose Antonio Martinez wrote:

yes, i know that max_connections limit the number of
connections to the postgresql server, but it is a
global limit for all the databases which are in the
server. I am looking for a way of configuring
postgresql for limiting connections per database at a
shared database server enviroment. In mysql it is easy
becouse there are a parameter for it.

Oops... sorry. I think there is no way. Maybe Your connection
pool can do this?

So long,
-tb

--- Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>
escribió: > 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.

So long,
-tb

--
Thomas Beutin tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

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