Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Дата
Msg-id 9469.1322606995@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Ответы Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?  (Heiko Wundram <modelnine@modelnine.org>)
Список pgsql-general
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <plk.zuber@gmail.com> writes:
> W dniu 29 listopada 2011 23:18 użytkownik Heiko Wundram
> <modelnine@modelnine.org> napisał:
>> Okay, that's too bad that there's no standard way for this.

> did you look at connlimit?
> http://www.netfilter.org/projects/patch-o-matic/pom-external.html#pom-external-connlimit

Another way that we've sometimes recommended people handle custom login
restrictions is
(1) use PAM for authentication
(2) find or write a PAM plugin that makes the kind of check you want

I think that there may well be a plugin out there already that does
this, or something close enough; but you'll have to do your own
research...

            regards, tom lane

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

Предыдущее
От: Filip Rembiałkowski
Дата:
Сообщение: Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Query Optimizer makes a poor choice