Thread: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
From
PG Doc comments form
Date:
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?
Re: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
From
"David G. Johnston"
Date:
On Tue, Jan 24, 2023 at 12:43 PM PG Doc comments form <noreply@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.