MIME-Version: 1.0
References: <CAAu_hGvBJXOkrjydkOXuDTX8eNMQn9+OMzPT_bcBcT-C9QsPVg@mail.gmail.com>
In-Reply-To: <CAAu_hGvBJXOkrjydkOXuDTX8eNMQn9+OMzPT_bcBcT-C9QsPVg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 24 Feb 2025 16:05:44 -0700
Message-ID: <CAKFQuwabejBgxy0R3715SuuT0V+dK7_VPUKUcw0eznN8HtCFPw@mail.gmail.com>
Subject: Re: Deleting idle connections
To: Yongye Serkfem <yserkfem@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007ab0ef062eeb6382"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwabejBgxy0R3715SuuT0V%2BdK7_VPUKUcw0eznN8HtCFPw%40mail.gmail.com>
Precedence: bulk

--0000000000007ab0ef062eeb6382
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Feb 24, 2025 at 3:50=E2=80=AFPM Yongye Serkfem <yserkfem@gmail.com>=
 wrote:

>
> I am having a series of idle connections and unable to delete them with a
> single command. Any help in realizing this would be greatly appreciated.
>
>
"deleting" really isn't the word used to describe this, terminate, kill, or
disconnect would be better choices.

You should be able to just use pg_terminate_backend in a select query to
accomplish your goal.

https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMI=
N-SIGNAL

Though usually you are better off fixing the problem at the source; or use
something like pgbouncer.

David J.

--0000000000007ab0ef062eeb6382
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Feb 24, 2025 at 3:50=E2=80=AFPM Yongye Serkfem &lt=
;<a href=3D"mailto:yserkfem@gmail.com">yserkfem@gmail.com</a>&gt; wrote:</s=
pan></div></div><div class=3D"gmail_quote gmail_quote_container"><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><br><div>I am havi=
ng a series of idle connections and unable to delete them with a single com=
mand. Any help in realizing this would be greatly appreciated.</div><div><b=
r></div></div></blockquote><div><br></div><div class=3D"gmail_default" styl=
e=3D"font-family:arial,helvetica,sans-serif">&quot;deleting&quot; really is=
n&#39;t the word used to describe this, terminate, kill, or disconnect woul=
d be better choices.</div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif">You should be able to just use =
pg_terminate_backend in a select query to accomplish your goal.</div><div c=
lass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br=
></div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif"><a href=3D"https://www.postgresql.org/docs/current/functions-admi=
n.html#FUNCTIONS-ADMIN-SIGNAL">https://www.postgresql.org/docs/current/func=
tions-admin.html#FUNCTIONS-ADMIN-SIGNAL</a></div><div class=3D"gmail_defaul=
t" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D=
"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Though usu=
ally you are better off fixing the problem at the source; or use something =
like pgbouncer.</div><div class=3D"gmail_default" style=3D"font-family:aria=
l,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_defa=
ult" style=3D"font-family:arial,helvetica,sans-serif"><br></div></div></div=
>

--0000000000007ab0ef062eeb6382--