Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmhH5-0098zs-3i for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 22:50:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tmhH3-00ADe0-Qk for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 22:50:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmhH3-00ADdE-B9 for pgsql-general@lists.postgresql.org; Mon, 24 Feb 2025 22:50:05 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tmhH0-000YcC-1W for pgsql-general@lists.postgresql.org; Mon, 24 Feb 2025 22:50:04 +0000 Received: by mail-pj1-x1029.google.com with SMTP id 98e67ed59e1d1-2fc32756139so7677183a91.1 for ; Mon, 24 Feb 2025 14:50:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740437402; x=1741042202; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=KXgR7hd9lLPYMfMAqFcYANZr9XcbKA8EOG88LOoB4+4=; b=Y2RhN4SFsE3CjRXpoSt7Iq5AI2jjkyaKB5BDZSdeRlVN4811cUl5VRhzcg3xsza+jW xmRnzAXyn3WtvDm7IkJVnHBqf+/B5IhRAocBdAc4zTwaW9jwqAuVp10WXCX2uvSxLjjY D7KAsVip/eC8rblGPhRNh8Hix7PkbEMKw3PiiF/KDS3a/wkuaxeVRHgul9xLWnMc7gGI 35ZBM3ibbriyGRV9IfUt+gqC1vWgxcF1ViuNhCDFIPpiIUW/hwJnOGTiBLc8LZ3wp91B OgPlJBtbvuCRNQRpN+Z1hl5L3I/a0iB/5AAyP9t0PLViavwrOQdYbUOsL1+ihpfXL2Z5 JX0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740437402; x=1741042202; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=KXgR7hd9lLPYMfMAqFcYANZr9XcbKA8EOG88LOoB4+4=; b=bpkHiWlnuLG2dp0re7Yb5wVxM/W7g7xImFdsdE+0PH6RaipVf+QkfiFqd3qt/vsnzj GYkkbBrhVQnbmw9EUQsm6fAA7kMf3ZwS+5Ec2B8BHeAMPUVkjtf2bSDJ6Z5ysWmgB94N BI2kuTzzJpblWyfrMuz0BMdcvgXQmMbI1GydakkvbVsHMtoPQBD/UGqEO9OrOVn2ztQ+ W4WmcvhPcEf4jARjA3f19J8Ils7mvRX1wCAEtiRj1uAzXc4hUETuHLeJwl0FuLfJEUhV q8gr8z19agfDRx6SfQ2JrFDE6Qt6sIWkS6cmsJ1uItyyLH04bHsB7/H0Anp5upbTCNcz 6RWg== X-Gm-Message-State: AOJu0YwJN92yUk/s+sd+Ozq2tVslm4ZmIZdmUhuLKaYGq/LfE0RvNYSV WmcSTdIH36pSNrDUfPQ35uHP0zLSxODkbgugFuJj+kyvEqTbB4sP8cqQS67ZRAnUmB+tADsXMgY KA0JvmS1DGQYyypPxls62ABPUeLldfQ== X-Gm-Gg: ASbGncvgNG/L5hAxpmk+KEwaumyuhackrEIPNaUflaRmjYfdwUkH5/R9PcTtJi4tjq8 B/D3C+DyfjJILdvR3hXBIvtpcCL+0mWxMjH6oQk1fQFk0FohXoZxanT1b7/4UZEGU6leLOBOD+3 e7Eb/VAWYk/K+xRg09/NvaKvdeydtB0Iz2TCB49pMASg== X-Google-Smtp-Source: AGHT+IHHq9gSu8aZZmm88IOw9/cV0huGpDwq7gi6x6+f2VK97bzMAl86zpPrDOeHONN6bDj7Mu3w6JM/ShxjfBXSqkk= X-Received: by 2002:a17:90b:37c7:b0:2fc:a3b7:108e with SMTP id 98e67ed59e1d1-2fce868cbedmr23490274a91.4.1740437402167; Mon, 24 Feb 2025 14:50:02 -0800 (PST) MIME-Version: 1.0 From: Yongye Serkfem Date: Mon, 24 Feb 2025 17:49:51 -0500 X-Gm-Features: AWEUYZlJZI8ipNLeEfWGtyks8WJSoe6DIotKcHV-9uz2MhrF_YFV6yZO6Qav_kU Message-ID: Subject: Deleting idle connections To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000001c3021062eeb29f4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001c3021062eeb29f4 Content-Type: text/plain; charset="UTF-8" Hi Everyone! 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. Regards Yong --0000000000001c3021062eeb29f4 Content-Type: text/html; charset="UTF-8"
Hi Everyone!
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.

Regards
Yong
--0000000000001c3021062eeb29f4--