Postgres Pro
Downloads
Home   >   mailing lists

Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? - Mailing list pgsql-general

From Tom Lane
Subject Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Date
Msg-id 9469.1322606995@sss.pgh.pa.us
Whole thread Raw
In response to Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Responses Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?  (Heiko Wundram <modelnine@modelnine.org>)
List pgsql-general
Tree view 
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <plk.zuber@gmail.com> writes:
> W dniu 29 listopada 2011 23:18 użytkownik Heiko Wundram
> <modelnine@modelnine.org> napisał:
>> Okay, that's too bad that there's no standard way for this.

> did you look at connlimit?
> http://www.netfilter.org/projects/patch-o-matic/pom-external.html#pom-external-connlimit

Another way that we've sometimes recommended people handle custom login
restrictions is
(1) use PAM for authentication
(2) find or write a PAM plugin that makes the kind of check you want

I think that there may well be a plugin out there already that does
this, or something close enough; but you'll have to do your own
research...

            regards, tom lane

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Next
From: Tomas Vondra
Date:
Subject: Re: Query Optimizer makes a poor choice