Hi! > 7 нояб. 2018 г., в 11:48, Evgeniy Efimkin <efim...@yandex-team.ru> написал(а): > 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 possible to 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 CONNECTION LIMIT for superuser but it ended about > Slony. > https://www.postgresql.org/message-id/1154351265.22367.210.camel%40coppola.muc.ecircle.de >
Current docs contain following description for SUPERUSER: >These clauses determine whether the new role is a “superuser”, who can >override all access restrictions within the database. Do we consider connection limit "access restriction"? Superuser can avoid setting his connection limit if he do not need it. Best regards, Andrey Borodin.
