idle_session_timeout doc

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема idle_session_timeout doc
Дата
Msg-id 164262322735.31954.5814862771892121460@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: idle_session_timeout doc  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/runtime-config-client.html
Description:

Is there a way to alter users idle_session_timeout setting?  My
understanding is that it's a global setting.  The last sentence indicates
you can apply an idle session timeout to particular users:

idle_session_timeout (integer)
Terminate any session that has been idle (that is, waiting for a client
query), but not within an open transaction, for longer than the specified
amount of time. If this value is specified without units, it is taken as
milliseconds. A value of zero (the default) disables the timeout.

Unlike the case with an open transaction, an idle session without a
transaction imposes no large costs on the server, so there is less need to
enable this timeout than idle_in_transaction_session_timeout.

Be wary of enforcing this timeout on connections made through
connection-pooling software or other middleware, as such a layer may not
react well to unexpected connection closure. It may be helpful to enable
this timeout only for interactive sessions, perhaps by applying it only to
particular users.

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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: gettext instructions for Windows seems wrong
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: idle_session_timeout doc