MIME-Version: 1.0
References: <167458061960.2667301.833819130259765379@wrigleys.postgresql.org>
In-Reply-To: <167458061960.2667301.833819130259765379@wrigleys.postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 24 Jan 2023 12:58:23 -0700
Message-ID: 
 <CAKFQuwZjexJ-VsCne5vf7BCXFLMaFn4bhsOSNEJS9f+FqHS_ew@mail.gmail.com>
Subject: Re:
 https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
To: troy@frericks.us, pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002311e005f307f1ac"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZjexJ-VsCne5vf7BCXFLMaFn4bhsOSNEJS9f%2BFqHS_ew%40mail.gmail.com>
Precedence: bulk

--0000000000002311e005f307f1ac
Content-Type: text/plain; charset="UTF-8"

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.

--0000000000002311e005f307f1ac
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Jan 24, 2023 at 12:43 PM PG Doc comments form &lt;=
<a href=3D"mailto:noreply@postgresql.org">noreply@postgresql.org</a>&gt; wr=
ote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">The following documentation comment has been l=
ogged on the website:<br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/15/sql-alterdatabase.html"=
 rel=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/15/sq=
l-alterdatabase.html</a><br>
Description:<br>
<br>
Would love to see more information about each of the ALTER DATABASE<br>
parameters... a specific... &quot;connlimit&quot;... -1 means no connection=
s, but what<br>
does 0 mean? Are there users that connect even though the connection limit<=
br>
is exceeded. Is there special allowances for other database connections, ie=
<br>
backups?<br></blockquote><div><br></div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif">I would expect superuser roles =
to ignore all of those options.=C2=A0 Everyone else, not so much.=C2=A0 con=
nlimit=3D0 should have the same effect as allowcon=3Dfalse</div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></d=
iv><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-s=
erif">There is some enhancement at the margins here but unless you are tryi=
ng to do unusual stuff it should be working as one would intuitively expect=
.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif"><br></div><div class=3D"gmail_default" style=3D"font-family:arial=
,helvetica,sans-serif">David J.</div><div class=3D"gmail_default" style=3D"=
font-family:arial,helvetica,sans-serif"><br></div></div></div>

--0000000000002311e005f307f1ac--