Re: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/
Дата
Msg-id CAKFQuwZjexJ-VsCne5vf7BCXFLMaFn4bhsOSNEJS9f+FqHS_ew@mail.gmail.com
обсуждение исходный текст
Ответ на https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
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.

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Naming of network_ops vs. inet_ops for SP-GIST
Следующее
От: Tom Lane
Дата:
Сообщение: Re: gen_random_uuid is only available with pgcrypto enabled