Re: Limit number connections by IP - Mailing list pgsql-general

From Stefan Kaltenbrunner
Subject Re: Limit number connections by IP
Date
Msg-id 46976113.5040007@kaltenbrunner.cc
Whole thread Raw
In response to Limit number connections by IP  (tabai <tabai.net@gmail.com>)
Responses Re: Limit number connections by IP
List pgsql-general
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

pgsql-general by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Limit connections per username
Next
From: imageguy
Date:
Subject: Re: Updates/Changes to a database