Обсуждение: limiting number of connections from specific host or by user
We are having a problem where we are running out of connections due to a in-house tool that creates abnormal amount of connections due to fluctuating loads that we cannot control. Ideally, the tool could be re-written to take into account for those situations, but due to its complexity we don't have the time to do so. I am trying to come up with a solution to block incoming connections when they reach a certain hard limit. Is there any way from PostgreSQL user authentication or other methods to cap connection count by user or by host? I had considered creating a firewall rule after detecting a certain amount of established connection from a particular host, but this seems very inflexible as well. Any ideas or suggestions appreciated. Sincerely, Kenji
On Wed, May 10, 2006 at 12:06:46PM -0700, Kenji Morishige wrote: > Is there any way from PostgreSQL user authentication or other > methods to cap connection count by user or by host? What version are you running? 8.1 has per-user and per-database connection limits; search for CONNECTION LIMIT in the following documentation: http://www.postgresql.org/docs/8.1/interactive/sql-alteruser.html http://www.postgresql.org/docs/8.1/interactive/sql-alterrole.html http://www.postgresql.org/docs/8.1/interactive/sql-alterdatabase.html -- Michael Fuhr
sweet! Thanks for the great info. We have been planning to upgrade when we find a good window. Thank you! -Kenji On Wed, May 10, 2006 at 01:57:24PM -0600, Michael Fuhr wrote: > On Wed, May 10, 2006 at 12:06:46PM -0700, Kenji Morishige wrote: > > Is there any way from PostgreSQL user authentication or other > > methods to cap connection count by user or by host? > > What version are you running? 8.1 has per-user and per-database > connection limits; search for CONNECTION LIMIT in the following > documentation: > > http://www.postgresql.org/docs/8.1/interactive/sql-alteruser.html > http://www.postgresql.org/docs/8.1/interactive/sql-alterrole.html > http://www.postgresql.org/docs/8.1/interactive/sql-alterdatabase.html > > -- > Michael Fuhr