From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | troy(at)frericks(dot)us, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/ |
Date: | 2023-01-24 19:58:23 |
Message-ID: | CAKFQuwZjexJ-VsCne5vf7BCXFLMaFn4bhsOSNEJS9f+FqHS_ew@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Tue, Jan 24, 2023 at 12:43 PM PG Doc comments form <
noreply(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-01-24 20:03:37 | Re: gen_random_uuid is only available with pgcrypto enabled |
Previous Message | PG Doc comments form | 2023-01-24 17:25:06 | Naming of network_ops vs. inet_ops for SP-GIST |