Re: Feature request: per user connections limit

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: pasman pasmañski <pasman(dot)p(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Feature request: per user connections limit
Date: 2011-08-27 19:13:04
Message-ID: 87obzaekhr.fsf@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

pasman pasmañski <pasman(dot)p(at)gmail(dot)com> writes:

> Hi.
>
> Is this possible to limit number of connections for given user/role?
> Postgres 8.4.8.

Yes. Read up on ...

create/alter role

alter role $role connection limit 10;

> ------------
> pasman
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 305.321.1144

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tarlika Elisabeth Schmitz 2011-08-27 20:14:21 PL/pgSQL: SELECT INTO only if result count = 1
Previous Message ajay kamath 2011-08-27 18:29:08 Re: