Обсуждение: Limit number connections by IP

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?

Thanks

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

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