pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
2+ messages / 2 participants
[nested] [flat]
* https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
@ 2023-01-24 17:16 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2023-01-24 17:16 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: troy@frericks.us
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
@ 2023-01-24 19:58 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2023-01-24 19:58 UTC (permalink / raw)
To: troy@frericks.us; pgsql-docs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-01-24 19:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-24 17:16 https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/ PG Doc comments form <noreply@postgresql.org>
2023-01-24 19:58 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox