Connection limit doesn't work for superuser - Mailing list pgsql-hackers

From Evgeniy Efimkin
Subject Connection limit doesn't work for superuser
Date
Msg-id 1924571541580524@iva5-815ce03d682b.qloud-c.yandex.net
Whole thread Raw
Responses Re: Connection limit doesn't work for superuser
List 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 by date:

Previous
From: "Kato, Sho"
Date:
Subject: RE: Performance improvements of INSERTs to a partitioned table
Next
From: Fabien COELHO
Date:
Subject: Re: csv format for psql