Re: limiting connections per user/database - Mailing list pgsql-patches

From Karel Zak
Subject Re: limiting connections per user/database
Date
Msg-id 1119882083.4214.8.camel@petra
Whole thread Raw
In response to Re: limiting connections per user/database  (Petr Jelínek <pjmodos@parba.cz>)
List pgsql-patches
On Sun, 2005-06-26 at 20:52 +0200, Petr Jelínek wrote:
> Alvaro Herrera wrote:
>
> >I don't think this approach is very user-friendly.  I'd vote for the
> >catalog approach, I think.
> >
> >
> Ok I am fine with both but catalog changes would mean more hacking of
> ALTER DATABASE and ALTER USER.

IMHO Oracle has better solution for per-user setting:

CREATE PROFILE <name>
   SESSIONS_PER_USER <int>
   CONNECT_TIME <int>
   IDLE_TIME <int>;

ALTER USER <name> PROFILE <name>;


    karel

--
Karel Zak <zakkr@zf.jcu.cz>


pgsql-patches by date:

Previous
From: Michael Fuhr
Date:
Subject: PL/Python error checking
Next
From: "Luke Lonergan"
Date:
Subject: Re: COPY FROM performance improvements