From: Md Arqum Farooqui <Md.Farooqui@india.nec.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: PostgreSQL(v9.6.5) not releasing old/inactive IDLE connections
Thread-Topic: PostgreSQL(v9.6.5) not releasing old/inactive IDLE connections
Thread-Index: Adfr/u8hhhKsYBBvT7qPpQmZH9v/fw==
Date: Wed, 8 Dec 2021 06:45:38 +0000
Message-ID: 
 <OS3PR01MB581659FF3F8020F174751B4BA76F9@OS3PR01MB5816.jpnprd01.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?+YDxdsHo5v6Y6Iul/MKrJdrRLdsm9ITClejbXyOBT5d4r4i0pJrfy/Ksf0I6?=
 =?us-ascii?Q?3SqL66mvID1mxbmiNXGGuPA2bRBv0gSAI3MhDIoL+DYV5IBXHcPf5AoNXRPp?=
 =?us-ascii?Q?g5RAg2U8yHeTG7RNpBEOMMzNjqP05Beyn6z1YmNIpqBz21Efc30tcRlmUyDM?=
 =?us-ascii?Q?Pf44LlRd96M/JbDb3ggbNdqgfSnJ5amsRK7SE6adkEPY4xigv+rpyCaTDSes?=
 =?us-ascii?Q?Xq0+PfEFLyN3jcZ0McYWdA0l8iDIcunTNfjOqJ5MV89vMRgEdKRExutTvJ+j?=
 =?us-ascii?Q?QqOaUG3P6ZuR4aDsQVwgvbvrf7KI+itvzWDO9Wy7gUEOAWEImb5ubWntEu9n?=
 =?us-ascii?Q?8hpjKk3mXptc0o5saysaZCbEZmHsmAnqAjKRQhyXK7o+NFz0d6jyS+UirXZT?=
 =?us-ascii?Q?h+zl+yL0DWZFcvM3C8IW2WoZ0H+EIpFN5IL6Pb3zIOt+PnLQQaMWqbrm0kBZ?=
 =?us-ascii?Q?kr6KIEek25qm2SkGXhEO2eX5seb1elpflLtxDxHw4dq2QYwIsQ4fkIoYImS4?=
 =?us-ascii?Q?W+FapHqtXUyuAkgmvai9Hzn8/s/U4aPVWPkrUY4leRS0aDp2RU95m97rV9Xw?=
 =?us-ascii?Q?JXahtX2sXs7OoQxNCQWrY1VD62hhLxJxteH012qh7u2TXOyhan4hEoJUtRNF?=
 =?us-ascii?Q?/Z3FDPnktC6aJ7gv0Y1fAl5Z3N/M+qppF+cJSIZEhAOVhUfF0UfUDWkcyFCY?=
 =?us-ascii?Q?SGldBP4qEoBT1JTQEVz4+YGO9apuV5sEPf4hoynF31cDZR21OWjIe7cLkPtq?=
 =?us-ascii?Q?eZVTP7B4TCO6s3H61qGqiRLXEBWa5rIRTV0VUzkXhpE9SSobvayHq3SeB7P9?=
 =?us-ascii?Q?v0LMr9opAz/O8F5VWhRj/YEfEBZ9XJTRckPyQEV/anKLmDjEIIihZAjbqTu9?=
 =?us-ascii?Q?HVCKp5hI9a0RyWg0at0Tz5YNi/do/44XJGECSWwoozQ2IXxfLem9lyk3HcXD?=
 =?us-ascii?Q?ubAyiEPYcJzMGx/0zazb6EoxVeFWZC8N1rF+8piviQ3iSMJFs+AWZub3q//6?=
 =?us-ascii?Q?4Eaag9bEOIcN3v0lytJgZE+2ZkAUZl68T583Nn50iyfB/gdf3g/Cledd8QaV?=
 =?us-ascii?Q?T39661FFHKeI7VDEZ0NFEeDIpQsFlpb4zI8GZPa5ZxmvyCOEa5tOqJnfXh7Z?=
 =?us-ascii?Q?KoaymUMxwjXwhbznewKSIT5zxCiDrBiCIAz91ZXY9gEEuYPRaFvVL8iPJNIp?=
 =?us-ascii?Q?CiyP4tq7jP+EFzRu2myeA1mH4N+bWjJG66R4HHxJAmFqAKOdvmBfk1TaVDgF?=
 =?us-ascii?Q?FU6SSA7xlTSRLF7JZgE7JQ2sraEfqPQLoTmd1Pq3LZfd3Ih7X8vuNYbfl9Wc?=
 =?us-ascii?Q?2sWhQgDhXzp2oVMIcefn2TP3X4Ix5j3dJVmWT445rGpUscQGNyyobCArUtMO?=
 =?us-ascii?Q?AhN0ysLC0IqfK3Qyi5hTmCZPqdJ0pXqDcGlSMRKPAhsQy6OKgWz+YXvg7E7P?=
 =?us-ascii?Q?FfAkpVFlv5/9sNGyw7Hbu4R2u1en+j8d2156+n0J1Zc1WL3nIq91NaVX2sT2?=
 =?us-ascii?Q?u4toQ+ynS09j4+J2ioXDIXMyx0NEKjzaQJjBCP1hwZvZhYvFlPlR16kE0ZSe?=
 =?us-ascii?Q?JCm9ya2LGKcPGyHl9ZThhECWM+OoOjbTEzu0Tj8RyAyJaBg1In5MBjPQBkTZ?=
 =?us-ascii?Q?Ykq1C4W9z2Ls2RfZbKMmCFNXLxOU1rvdg1C4Hq0b8DiDnGXS8bDhlgrynWw0?=
 =?us-ascii?Q?jahR2ASHtN/QgK7H3UPnXpErbbEgLwSjYDr/bu3wr6EAUWoasyPFN9ZjbB9q?=
 =?us-ascii?Q?Srr/R3Na1g=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_OS3PR01MB581659FF3F8020F174751B4BA76F9OS3PR01MB5816jpnp_"
MIME-Version: 1.0
X-OriginatorOrg: india.nec.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: OS3PR01MB5816.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 c8b9f991-7b70-4585-a82f-08d9ba1658ab
X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Dec 2021 06:45:38.8390
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: c2e2f202-eea9-46e0-81d4-4e3c2897622e
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 I5VqAg6GtxIzqJXic9h1DXDAnIJCk7Se94CFT7ZTkUM8I+iszuvbfVT7PxcZuYPcd3cw0uPy/PB0Ht8mAfPQEh4gZpDm9JoTGXvbZ8wg0cs=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSAPR01MB1843
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/OS3PR01MB581659FF3F8020F174751B4BA76F9%40OS3PR01MB5816.jpnprd01.prod.outlook.com>
Precedence: bulk

--_000_OS3PR01MB581659FF3F8020F174751B4BA76F9OS3PR01MB5816jpnp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm facing "Too many clients already" error frequently with my PostgreSQL (=
v9.6.5) container (i.e. being used along with CKAN application i.e. A open =
source data management system<https://ckan.org/> ), I have observed that Po=
stgreSQL is not releasing IDLE connections from their end. I have set "max_=
connetions =3D 100" in postgresql.

Please provide your suggestions on below queries:

1. Why PostgreSQL is not releasing IDLE connection? (If we leave the setup =
then postgres keep IDLE  connection even for 1 month, after that I have to =
restart the Postgres)
2. Is there any parameter or any solution by which i can remove unused old =
IDLE connection regularly?


Thanks and Regards,
Arqum farooqui


________________________________
The contents of this e-mail and any attachment(s) are confidential and inte=
nded for the named recipient(s) only. It shall not attach any liability on =
the originator or NEC Corporation India Private Limited or its affiliates. =
Any views or opinions presented in this email are solely those of the autho=
r and may not necessarily reflect the opinions of NEC Corporation India Pri=
vate Limited or its affiliates. Any form of reproduction, dissemination, co=
pying, disclosure, modification, distribution and / or publication of this =
message without the prior written consent of the author of this e-mail is s=
trictly prohibited. If you have received this email in error please delete =
it and notify the sender immediately.

--_000_OS3PR01MB581659FF3F8020F174751B4BA76F9OS3PR01MB5816jpnp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-IN" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11.5pt;font-family:&quot;Ar=
ial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F8">Hi,
<br>
<br>
I'm facing &quot;Too many clients already&quot; error frequently with my Po=
stgreSQL (v9.6.5) container (i.e. being used along with CKAN application i.=
e.&nbsp;</span><a href=3D"https://ckan.org/" target=3D"_blank"><span style=
=3D"font-size:11.5pt;font-family:&quot;Arial&quot;,sans-serif;background:#F=
8F8F8">A
 open source data management system</span></a><span style=3D"font-size:11.5=
pt;font-family:&quot;Arial&quot;,sans-serif;color:#1D1C1D;background:#F8F8F=
8">&nbsp;), I have observed that PostgreSQL is not releasing IDLE connectio=
ns from their end. I have set &quot;max_connetions =3D 100&quot;
 in postgresql.<br>
<br>
Please provide your suggestions on below queries:<br>
</span><span style=3D"font-size:11.5pt;font-family:&quot;Arial&quot;,sans-s=
erif;color:#1D1C1D"><br>
<span style=3D"background:#F8F8F8">1. Why PostgreSQL is not releasing IDLE =
connection? (If we leave the setup then postgres keep IDLE&nbsp; connection=
 even for 1 month, after that I have to restart the Postgres)</span><br>
<span style=3D"background:#F8F8F8">2. Is there any parameter or any solutio=
n by which i can remove unused old IDLE connection regularly?<br>
<br>
<br>
Thanks and Regards,<br>
Arqum farooqui<br>
<br>
<br>
<br>
<br>
</span></span><o:p></o:p></p>
</div>
<hr>
The contents of this e-mail and any attachment(s) are confidential and inte=
nded for the named recipient(s) only. It shall not attach any liability on =
the originator or NEC Corporation India Private Limited or its affiliates. =
Any views or opinions presented
 in this email are solely those of the author and may not necessarily refle=
ct the opinions of NEC Corporation India Private Limited or its affiliates.=
 Any form of reproduction, dissemination, copying, disclosure, modification=
, distribution and / or publication
 of this message without the prior written consent of the author of this e-=
mail is strictly prohibited. If you have received this email in error pleas=
e delete it and notify the sender immediately.
</body>
</html>

--_000_OS3PR01MB581659FF3F8020F174751B4BA76F9OS3PR01MB5816jpnp_--