tabai (taba...@gmail.com)

Profile | Posts (2)

User Information

Display Name:

tabai

Partial Email Address:

taba...@gmail.com

Posts:

2	total
2	in PostgreSQL - General

2 Most Recent

1) tabai Re: [GENERAL] Limit number connections by IP

+1 vote

Thaks Stefan ---------------------------(end of broadcast)--------------------------- TIP 1: if...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

Thaks Stefan



On 13 jul, 12:25, [email protected: s...@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



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [email protected: majo...@postgresql.org] so that your
       message can get through to the mailing list cleanly

2) tabai [GENERAL] Limit number connections by IP

+1 vote

Hi I know that i can limited the total number of connections in postgresql.conf with...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [email protected: majo...@postgresql.org] so that your
       message can get through to the mailing list cleanly

Highlight

Profile | Posts (2)

Home > People > tabai