SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-24-2008, 06:15 PM
| ||||
| ||||
 Limiting the number of connections for one user Hello, We clearly have a bug in our application: sometimes for reasons we have not been able to understand yet, the application will start creating connection like madness (several dozens in a matter of minutes). This eats up too quickly the number of connections we have available on the server and is not healthy anyway. We have narrowed the problem down to only 2 users having had this issue over the past few days. Whilst we are investigating what happens I am wondering if there are anyway to limit the number of connection a specific IP address can make to a server; this would not solve the user's issue but prevent it from spreading and affecting every other users. I googled but did not find anything remotely related to this. Thanks for your thoughts Didier -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice      |
|
04-24-2008, 06:15 PM
| ||||
| ||||
| Re: Limiting the number of connections for one user am Thu, dem 24.04.2008, um 11:18:19 +0200 mailte Didier Gasser-Morlay folgendes: > Hello, > > We clearly have a bug in our application: sometimes for reasons we > have not been able to understand yet, the application will start > creating connection like madness (several dozens in a matter of > minutes). This eats up too quickly the number of connections we have > available on the server and is not healthy anyway. > > We have narrowed the problem down to only 2 users having had this > issue over the past few days. > > Whilst we are investigating what happens I am wondering if there are > anyway to limit the number of connection a specific IP address can > make to a server; this would not solve the user's issue but prevent it > from spreading and affecting every other users. Do you have a own user for this connection? If so, you can limit the connections per user, see alter user <name> connection limit <limit>. I don't know a way to set a limit per IP with postgresql, but i think, you can do that with iptables (depending on your operating system). Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice |
Linear Mode
