On Tue, Jan 24, 2023 at 12:43 PM PG Doc comments form < nore...@postgresql.org> wrote:
> The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/sql-alterdatabase.html > Description: > > Would love to see more information about each of the ALTER DATABASE > parameters... a specific... "connlimit"... -1 means no connections, but > what > does 0 mean? Are there users that connect even though the connection limit > is exceeded. Is there special allowances for other database connections, ie > backups? > I would expect superuser roles to ignore all of those options. Everyone else, not so much. connlimit=0 should have the same effect as allowcon=false There is some enhancement at the margins here but unless you are trying to do unusual stuff it should be working as one would intuitively expect. David J.