Postgres Pro
Downloads
Home   >   mailing lists

Re: Handling idle connections - Mailing list pgsql-admin

From Rajesh Kumar
Subject Re: Handling idle connections
Date
Msg-id CAJk5AtZ5XNhvwJqE3MK1SZ5ufHraqtN7EsR4WgadXfvdrgyNOA@mail.gmail.com
Whole thread Raw
In response to Re: Handling idle connections  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
Could u give me a tip on how to figure out where they are coming and what do u mean exactly by saying "fixing" them

On Sun, 24 Sept 2023, 18:25 Scott Ribe, <scott_ribe@elevated-dev.com> wrote:
> On Sep 24, 2023, at 1:27 AM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
>
> Hi
>
> What is the best way to handle idle connections other than manually killing idle connections if I do not have connection pooler.

1) configure idle timeouts

2) figure out where they're coming from and fix the client

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Handling idle connections
Next
From: Scott Ribe
Date:
Subject: Re: Handling idle connections