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 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
