Postgres Pro
Downloads
Home   >   mailing lists

Re: Feature request: per user connections limit - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Feature request: per user connections limit
Date
Msg-id 87obzaekhr.fsf@comcast.net
Whole thread Raw
In response to Feature request: per user connections limit  (pasman pasmański <pasman.p@gmail.com>)
Responses Re: Feature request: per user connections limit
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: ajay kamath
Date:
Subject: Re:
Next
From: Kenneth McDonald
Date:
Subject: Still no way to install PostGres on os x Lion?