Re: Limit number connections by IP

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: tabai <tabai(dot)net(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Limit number connections by IP
Date: 2007-07-13 11:25:07
Message-ID: 46976113.5040007@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tabai 2007-07-13 11:52:22 Re: Limit number connections by IP
Previous Message Stefan Kaltenbrunner 2007-07-13 11:20:05 Re: Limit connections per username