Обсуждение: limiting connections on "per database/per user" basis

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.

Cheers!

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