Обсуждение: postgresql mysql max connections
In mysql there are two configuration parameters for
limiting connections:
max_user_connections
max_connections
the first limits the number of concurrent connexions
from a same user, is there an equivalent in
postgresql?
Postgresql seems to limit only the total number of
connexions with the parameter 'max_connections'
(postgresql.conf)
thanks.
___________________________________________________
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito
en http://moviles.yahoo.es
There is no equivilant setting in postgresql, though this doesn't seem like a terribly hard feature to add. You might want to submit a proposal on -hackers, or better yet, a patch. :-) Robert Treat On Wed, 2003-02-12 at 13:36, Jose Antonio Martinez wrote: > In mysql there are two configuration parameters for > limiting connections: > > max_user_connections > max_connections > > the first limits the number of concurrent connexions > from a same user, is there an equivalent in > postgresql? > > Postgresql seems to limit only the total number of > connexions with the parameter 'max_connections' > (postgresql.conf) > > thanks. >
I think the big question is where there is any value in limiting the number of connections "per user". I haven't seen anyone ask for that before, so I haven't seen much demand for it. --------------------------------------------------------------------------- Robert Treat wrote: > There is no equivilant setting in postgresql, though this doesn't seem > like a terribly hard feature to add. You might want to submit a proposal > on -hackers, or better yet, a patch. :-) > > Robert Treat > > On Wed, 2003-02-12 at 13:36, Jose Antonio Martinez wrote: > > In mysql there are two configuration parameters for > > limiting connections: > > > > max_user_connections > > max_connections > > > > the first limits the number of concurrent connexions > > from a same user, is there an equivalent in > > postgresql? > > > > Postgresql seems to limit only the total number of > > connexions with the parameter 'max_connections' > > (postgresql.conf) > > > > thanks. > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> I think the big question is where there is any value in limiting the > number of connections "per user". I haven't seen anyone ask for that > before, so I haven't seen much demand for it. This is important in a hosting environment where you have a shared db-server. Then you can limit the connections for each customer and a single customer is not able to get all connections, thus denying access for other customers. Regards, Bjoern
yes, i am thinking about installing and configuring postgresql in a contest of shared db-server. I think postgresql has more funcionalities than mysql ( trigger, sql92, ...) but ... mysql seems to be more configurable for shared db server and is implementing more and more funcionalities (most beta at the moment). is there any value for limiting the number of connections "per user" in postgresql? ----- Original Message ----- From: "Bjoern Metzdorf" <bm@turtle-entertainment.de> To: "Bruce Momjian" <pgman@candle.pha.pa.us>; "Robert Treat" <xzilla@users.sourceforge.net> Cc: "Jose Antonio Martinez" <lfbbes@yahoo.es>; <pgsql-admin@postgresql.org> Sent: Thursday, February 13, 2003 9:00 PM Subject: Re: [ADMIN] postgresql mysql max connections > > I think the big question is where there is any value in limiting the > > number of connections "per user". I haven't seen anyone ask for that > > before, so I haven't seen much demand for it. > > This is important in a hosting environment where you have a shared > db-server. Then you can limit the connections for each customer and a single > customer is not able to get all connections, thus denying access for other > customers. > > Regards, > Bjoern > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) ___________________________________________________ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es