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
