Thread: max connections
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? ___________________________________________________ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es
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