From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Idle_session_timeout
Date: Wed, 4 Oct 2023 09:51:19 -0600
Message-ID: <4DA883D1-36E4-455D-9998-50FAA41EA0F0@elevated-dev.com> (raw)
In-Reply-To: <CAJk5AtZ9b11Jbahr8upTgtdq_sNCvqmoQVNH1drPxSKPZsYLWg@mail.gmail.com>
References: <CAJk5AtZ9b11Jbahr8upTgtdq_sNCvqmoQVNH1drPxSKPZsYLWg@mail.gmail.com>
> On Oct 4, 2023, at 9:38 AM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
>
> 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.
You're not doing anything incorrectly. You just have a mismatch between expectations on the database vs application side.
Either:
the application is allowed to keep connections open permanently, and the database has to be configured to support enough connections
-OR-
the database has a more limited number of connections, and the application manages connecting and disconnecting
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, rajeshkumar.dba09@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Idle_session_timeout
In-Reply-To: <4DA883D1-36E4-455D-9998-50FAA41EA0F0@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox