From: David G. Johnston <david.g.johnston@gmail.com>
To: troy@frericks.us
To: pgsql-docs@lists.postgresql.org
Subject: Re: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
Date: Tue, 24 Jan 2023 12:58:23 -0700
Message-ID: <CAKFQuwZjexJ-VsCne5vf7BCXFLMaFn4bhsOSNEJS9f+FqHS_ew@mail.gmail.com> (raw)
In-Reply-To: <167458061960.2667301.833819130259765379@wrigleys.postgresql.org>
References: <167458061960.2667301.833819130259765379@wrigleys.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: david.g.johnston@gmail.com, troy@frericks.us, pgsql-docs@lists.postgresql.org
Subject: Re: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
In-Reply-To: <CAKFQuwZjexJ-VsCne5vf7BCXFLMaFn4bhsOSNEJS9f+FqHS_ew@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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