Re: postgresql mysql max connections

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