Обсуждение: Feature request: per user connections limit

Hi.

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

--
------------
pasman

pasman pasmañski <pasman.p@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 305.321.1144

Thanks, i'll try it tomorrow