Re: postgresql mysql max connections

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: Jose Antonio Martinez <lfbbes(at)yahoo(dot)es>, pgsql-admin(at)postgresql(dot)org
Subject: Re: postgresql mysql max connections
Date: 2003-02-13 19:31:21
Message-ID: 200302131931.h1DJVLa06222@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-02-13 19:34:16 Re: Auth users and command pg_passwd
Previous Message Andres Ledesma 2003-02-13 19:21:50 Re: [ADMIN] help me!!