Re: Limit number connections by IP

Поиск
Список
Период
Сортировка
От tabai
Тема Re: Limit number connections by IP
Дата
Msg-id 1184327542.854706.209070@22g2000hsm.googlegroups.com
обсуждение исходный текст
Ответ на Re: Limit number connections by IP  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-general
Thaks Stefan


On 13 jul, 12:25, ste...@kaltenbrunner.cc (Stefan Kaltenbrunner)
wrote:
> tabai wrote:
> > Hi
>
> > I know that i can limited the total number of connections in
> > postgresql.conf with max_connections, but... can i limite  the max
> > number of connections from an specific IP?
>
> > For example y like have total max connections of 40 buy the same ip
> > can't have more than 5 connections open.
>
> > It is possible?
>
> no - you can limit the maximum numbers of connections on a per database
> and also a per role base. If you really need a per source address
> limitation look into using whatever firewall solution is available on
> your OS.
>
> Stefan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match



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

Предыдущее
От: Rajarshi Guha
Дата:
Сообщение: Re: count the number of bits set to 1 in a bit string field
Следующее
От: Janning Vygen
Дата:
Сообщение: createing indexes on large tables and int8