Thread: Limit connections per user

Limit connections per user

From
"Stanislaw Tristan"
Date:

I need to limit the connection number per each user. How can I do this?

 

Stanislaw Tristan

Kyiv, Ukraine

E-mail: stas7775@i.com.ua

 

 

Re: Limit connections per user

From
Richard Huxton
Date:
Stanislaw Tristan wrote:
> I need to limit the connection number per each user. How can I do this?

There's no support for this in PG at the moment, just for total number
of connections. Might be worth looking at "pgpool" - that should be
fairly easy to modify to allow per-user limits.

--
   Richard Huxton
   Archonet Ltd