Re: limiting connections on "per database/per user" basis

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: limiting connections on "per database/per user" basis
Дата
Msg-id 200610301725.29572@hal.medialogik.com
обсуждение исходный текст
Ответ на limiting connections on "per database/per user" basis  ("Hakka Ville" <vhakka@gmail.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Hakka Ville"
Дата:
Сообщение: limiting connections on "per database/per user" basis
Следующее
От: Ganbold
Дата:
Сообщение: Re: postgresql books and convertion utilities