pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlimiting number of connections from specific host or by user
3+ messages / 2 participants
[nested] [flat]
* limiting number of connections from specific host or by user
@ 2006-05-10 19:06 Kenji Morishige <kenjim@juniper.net>
0 siblings, 1 reply; 3+ messages in thread
From: Kenji Morishige @ 2006-05-10 19:06 UTC (permalink / raw)
To: pgsql-admin; +Cc: kenjim@juniper.net
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: limiting number of connections from specific host or by user
@ 2006-05-10 19:57 Michael Fuhr <mike@fuhr.org>
parent: Kenji Morishige <kenjim@juniper.net>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Fuhr @ 2006-05-10 19:57 UTC (permalink / raw)
To: Kenji Morishige <kenjim@juniper.net>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: limiting number of connections from specific host or by user
@ 2006-05-10 21:12 Kenji Morishige <kenjim@juniper.net>
parent: Michael Fuhr <mike@fuhr.org>
0 siblings, 0 replies; 3+ messages in thread
From: Kenji Morishige @ 2006-05-10 21:12 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin; kenjim@juniper.net
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-05-10 21:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-10 19:06 limiting number of connections from specific host or by user Kenji Morishige <kenjim@juniper.net>
2006-05-10 19:57 ` Michael Fuhr <mike@fuhr.org>
2006-05-10 21:12 ` Kenji Morishige <kenjim@juniper.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox