Limiting simultaneous connections
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
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!
Show quoted text
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
On Tue, 5 Jun 2001, Tauren Mills wrote:
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?
I don't believe that there's any way to do that kind of limiting right
now. I'm not sure what would be involved given the current connection
system.
I don't believe its possible to do that at this time.
Tim
----- Original Message -----
From: "Tauren Mills" <tauren@servlets.net>
To: <pgsql-admin@postgresql.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
Show quoted text
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?
Stephan and Tim,
Thanks for your response. Not exactly what I was hoping for, but at least I
don't need to keep searching any longer.
Tauren
Show quoted text
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
Sent: Tuesday, June 05, 2001 3:15 PM
To: Tauren Mills
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Limiting simultaneous connectionsOn Tue, 5 Jun 2001, Tauren Mills wrote:
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?
I don't believe that there's any way to do that kind of limiting right
now. I'm not sure what would be involved given the current connection
system.