limiting number of connections from specific host or by user
В списке pgsql-admin по дате отправления:
| От | Kenji Morishige |
|---|---|
| Тема | limiting number of connections from specific host or by user |
| Дата | |
| Msg-id | 20060510190646.GA12986@juniper.net обсуждение исходный текст |
| Ответы |
Re: limiting number of connections from specific host or by user
|
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера