Connection limit doesn't work for superuser

Поиск
Список
Период
Сортировка
От Evgeniy Efimkin
Тема Connection limit doesn't work for superuser
Дата
Msg-id 1924571541580524@iva5-815ce03d682b.qloud-c.yandex.net
обсуждение исходный текст
Ответы Re: Connection limit doesn't work for superuser  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers
Connection limit doesn't work for superuser
Hi hackers!
It would be nice if ALTER USER ... WITH CONNECTION LIMIT will work for superuser. It would protect against connection
leaks.e.g. we have two superusers, one of them reached connection limit but not max_connections, the other is still
possibleto connect to database and solve the problem. The current behaviour would be the same for the case with
rolconnlimit= -1. Superuser can execute NOLOGIN to another superuser and it works. I found previos discussion about
CONNECTIONLIMIT for superuser but it ended about Slony.
https://www.postgresql.org/message-id/1154351265.22367.210.camel%40coppola.muc.ecircle.de


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kato, Sho"
Дата:
Сообщение: RE: Performance improvements of INSERTs to a partitioned table
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: csv format for psql