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: 2006-10-31 01:25:29
Message-ID: 200610301725.29572@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ganbold 2006-10-31 01:50:00 Re: postgresql books and convertion utilities
Previous Message Hakka Ville 2006-10-31 01:17:01 limiting connections on "per database/per user" basis