Skip site navigation (1) Skip section navigation (2)

Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?

From: Heiko Wundram <modelnine(at)modelnine(dot)org>
To: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Date: 2011-11-30 08:20:17
Message-ID: 4ED5E741.4080100@modelnine.org (view raw or flat)
Thread:
Lists: pgsql-general
Am 29.11.2011 23:44, schrieb Filip Rembiałkowski:
> did you look at connlimit?
> http://www.netfilter.org/projects/patch-o-matic/pom-external.html#pom-external-connlimit
> AFAIK, it applies only to ESTABLISHED state, so maybe it suits you.

No, I didn't, and THANKS! That's exactly the hint I needed. I tried to 
use the hashlimit and/or recent matches with high burst rates and low 
limits, but that didn't work, and that's what I was hinting at.

> I'm not sure how do you want to allow "many connections being created
> almost at once" and "limit number of connections from same IP" at the
> same time?

The intention being that I'm trying to limit the total amount of 
connections per client to something around 20; the behaviour of the 
clients is such that they create 10-15 connections in a very short burst 
(due to threaded accesses to the database), and (should) disconnect all 
of these in an interval of 10 minutes. When a client runs amok (which 
I've had twice this week), the batch of connections is not disconnected, 
and a single client gradually starts eating up all connections to the 
database, and thus hinders other clients from functioning. But: using 
connlimit should do the trick. I'll try that out immediately.

Thanks again!

-- 
--- Heiko.

In response to

pgsql-general by date

Next:From: Heiko WundramDate: 2011-11-30 08:23:25
Subject: Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Previous:From: Florian SchwendenerDate: 2011-11-30 08:09:59
Subject: Re: odbc_fdw

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group