Re: Idle_session_timeout
| От | Goran Pulevic |
|---|---|
| Тема | Re: Idle_session_timeout |
| Дата | |
| Msg-id | CABvV9a1cUJO=NnE_-jP+sTJ9xqB+Crfa65-yErJTS5F0j5pWnQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Idle_session_timeout (Rajesh Kumar <rajeshkumar.dba09@gmail.com>) |
| Ответы |
Re: Idle_session_timeout
|
| Список | pgsql-admin |
You need to talk to your application team and find out about their connection related timeouts. Things like max-idle-time, server-lifetime, etc. (They almost certainly use a db library which implements some kind of client side connection pool).
In short: their timeouts should be lower than the server's idle_session_timeout.
Something like: max-idle-time < server-lifetime < idle_session_timeout
In short: their timeouts should be lower than the server's idle_session_timeout.
Something like: max-idle-time < server-lifetime < idle_session_timeout
On Wed, 4 Oct 2023 at 17:41, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi all,I was facing issue with idle connections not closed.So, I thought of automating it and set the parameter idle_session_timeout to 5min. But I got a message from application team that they are getting jdbc error continuously and they are saying connection is getting terminated. So I had to turn it off now.How to use this parameter correctly?
В списке pgsql-admin по дате отправления: