Re: postgresql mysql max connections - Mailing list pgsql-admin

From Jose Antonio Martinez
Subject Re: postgresql mysql max connections
Date
Msg-id 004901c2d39e$d60042b0$0200a8c0@tomcat
Whole thread Raw
In response to Re: postgresql mysql max connections  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: P G
Date:
Subject: What is the default timeout setting?
Next
From: Aleksander Kmetec
Date:
Subject: Locale problems