Re: [ADMIN] Limiting simultaneous connections

From: "Tim Barnard" <tbarnard(at)povn(dot)com>
To: "Tauren Mills" <tauren(at)servlets(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [ADMIN] Limiting simultaneous connections
Date: 2001-06-05 22:19:30
Message-ID: 015801c0ee0d$9a8a14e0$a519af3f@hartcomm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

I don't believe its possible to do that at this time.

Tim

----- Original Message -----
From: "Tauren Mills" <tauren(at)servlets(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, June 05, 2001 12:30 PM
Subject: RE: [ADMIN] Limiting simultaneous connections

> I don't mean to be a pest, but I haven't heard anything back on this
subject
> and have been unable to locate any information about it in the manuals.
I'm
> not the only one interested in this since I've received mail from other
> people asking if I have an answer yet.
>
> Does anyone know if this is possible or not? Or can I be directed to the
> right resource to find out the answer?
>
> Thanks!
>
> > Is there a way to limit the number of simultaneous connections that any
> > given username can make to the database? For instance, I'd like
> > user1 to be
> > able to have no more than 5 simultaneous connections to the
> > database server,
> > but user2 can have 15 simultaneous connections.
> >
> > Also, can these connections be limited on a per user for the
> > entire database
> > server basis? Or can they be limited on a per user per database
> > basis? By
> > this I mean, can a user create up to 5 connections to one of
> > their databases
> > and then another 5 to one of their other databases (total of 10
> > connections
> > across the whole database server). Or can they be limited to a total of
5
> > for any connections to any of their databases?
> >
> > I will be using either 7.1.1 from RPM or 7.1.2 from source on Red
> > Hat Linux
> > 6.2 and 7.1.
> >
> > Thanks!
> > Tauren
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tauren Mills 2001-06-06 01:11:56 RE: Limiting simultaneous connections
Previous Message Stephan Szabo 2001-06-05 22:14:47 RE: Limiting simultaneous connections

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-05 22:21:10 Re: Vacuum problem on large table
Previous Message Andrew Gould 2001-06-05 22:19:29 Re: One question about postgresql