[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] limiting connections on "per database/per user" basis
From:       Alan Hodgson <ahodgson () simkin ! ca>
Date:       2006-10-31 1:25:29
Message-ID: 200610301725.29572 () hal ! medialogik ! com
[Download RAW message or body]

On Monday 30 October 2006 17:17, "Hakka Ville" <vhakka@gmail.com> wrote:
> Dear Sirs,
>
> I have to setup shared web-hosting and I think of limiting connections to
> PostgreSQL cluster on database/user basis.
>
> Any idea how to do that ?
>
> I simply don't want situation when single user (on of hundreds) will take
> all the available connections.

alter role foo connection limit xxx;


-- 
"Government big enough to supply everything you need is big enough to take
everything you have ... the course of history shows that as a government
grows, liberty decreases." -- Thomas Jefferson


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
[prev in list] [next in list] [prev in thread] [next in thread]