RE: Limiting simultaneous connections

Поиск
Список
Период
Сортировка
От Tauren Mills
Тема RE: Limiting simultaneous connections
Дата
Msg-id NBBBLBKDJMGDNPMDGAABAEPBADAB.tauren@servlets.net
обсуждение исходный текст
Ответ на Limiting simultaneous connections  ("Tauren Mills" <tauren@servlets.net>)
Ответы RE: Limiting simultaneous connections  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Hartwig Jens"
Дата:
Сообщение: AW: Listing rules !!!
Следующее
От: Hans-Jürgen Schönig
Дата:
Сообщение: serious connection problems