Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: limiting connections on "per database/per user" basis
- From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: limiting connections on "per database/per user" basis
- Date: Mon, 30 Oct 2006 17:25:29 -0800
- Message-id: <200610301725(dot)29572(at)hal(dot)medialogik(dot)com>
On Monday 30 October 2006 17:17, "Hakka Ville" <vhakka(at)gmail(dot)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
- References:
- limiting connections on "per database/per user" basis
- From: Hakka Ville
- limiting connections on "per database/per user" basis
- Prev by Date: limiting connections on "per database/per user" basis
- Next by Date: Re: postgresql books and convertion utilities
- Previous by thread: limiting connections on "per database/per user" basis
- Next by thread: Bad performance in bulky updates
- Indexes: