Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppE90-000143-Bk for pgsql-admin@arkaria.postgresql.org; Wed, 19 Apr 2023 20:11:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppE8z-0005lH-1W for pgsql-admin@arkaria.postgresql.org; Wed, 19 Apr 2023 20:11:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppE8y-0005kQ-LW for pgsql-admin@lists.postgresql.org; Wed, 19 Apr 2023 20:11:08 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ppE8s-000kNx-PL for pgsql-admin@lists.postgresql.org; Wed, 19 Apr 2023 20:11:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1681935060; i=shammat@gmx.net; bh=rfs84OsmXP5yk0lkPIYmyz17nI4g92mpJC76MzxYDro=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=esZI/IZu+0oM32kB/z4/zYelHJM7cMF2lzx+EDNzR/CrQfB9gu0v4ZKyxVp5zXDOm 8EBzrj4obGmz9XEPqTO0EzYkrLvrOg/Ca7iW3/9e4HxDTthhZPpRmQIVyFDPut4EIz Gv/FbOVxQMTK/c7vVvQ1ZOYTV7m+6Qe2mQoWa4oU6qSILibrzQpkJZIk1M9tfKz9+p E9XdUeRMrDz6CERlpkNevarChQMT6VguTagVQisPcQg7EySPmNS/0uuwQ9QAHwHZ7P gWCPrcQ9d2yOWe4UuW59yahvJk4dAA7t/z0maxodVRa0oKeUQUcadTZtjg4VsDvLM/ 5opSKypgoBuMg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.20] ([82.135.75.93]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1Mj8qd-1qUMJV0dvh-00fF2d for ; Wed, 19 Apr 2023 22:11:00 +0200 Subject: Re: pg_cancel_backend and pg_terminate_backend To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: Date: Wed, 19 Apr 2023 22:10:59 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:vvy4Z84HbUvc/QFWuQKvhgidduEoiIJmAZiZEZTapJ3Laj4nE0d Oy5YnmElxPd4fACOpRHZZoguiQuruRlKL3xXViXTebXzZyZJaFnaWvCalwBuu2ccMNodKfb vgIqrNPrh61LidwvqT2S5cMy0yjBbFSc5DxCX9qZUplcen7FChRK9D4qg6j4ejLHO17ToLV 4hBr6Ph5G8lgtOrHHA21g== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:YidZqLbg1Ic=;Pam9xONq4WHKZ8oBJYTCR0n6Qgl mKgLCYx770b+qGEgR0k67v8awlZc3p/ksmn46585fkRbT5ANO2VXeDU4NIDSzYuFPTS5SeCwe GkK7BBAFziinUUMkeTIkdHm/SAzLw89joXp9URawUOKJM8Tb2CMGBUR6oWipV26/mfd58Mp5m mfio0QU1rCp7JusB3/A0CtoNdSFoiGn4aSTXDJRphFa2S4BJr4vsJPGnX0VGo3xyf2tBoit/l il+BlZT0D1UMOZIgrHHVXa6AtrsfFw6/lhBOeapVk6KpULrpVtq6+pDADTHrRvp8J3d9cmbAe CA4Aj9MUkWP5VjW75Jw6YCrRKrhhtv1L2HTW9pY4lPmEXIAnHw2wGpEY8F43zTQdFykW+gUt1 JmyHsdk0vzsHzxw/MixQrYx2kleAmo79qA7srPWD2pH7OjBG/UN+ZgX+U4Xmz8l8WFMC7+i/T EwC+othpn/I2JG8OY5x3MUousBROkOrWzc5EzNMoSeAfVks4V8d2yDzGV3y4HzaHNl4vgobe7 54yqNoC4PwtdviTJYhmmYnBALMpTryACOXHMDUdaiWeZkcYFbYnHt5WMabPnZxK8t4MT6ORZB 1tDl4UaV8IKdciLP47WYXqUR2l4/tx8Hhii1ItvTv5Bhiur7KrBi8fyH20oOX9Bnv/8HO21ka PBAYdy1bnylm1tsZwvNXUfBNYPRTYOjbAuOnXV0E5SXgNXd/KPuSgwvLSDryamQObqTTqo4Wi MBatx2E5jWYuK6zyC31kmtwYgzJmIsc86d2ECtvWfJJzxHhryyNAXGfXJYFB5BTC8N2ZT1KrV QSroXo8QkULWStbmJZZQ1d7yuD7A9ukjpHFRvc4GM0K3cMeRxtGZxVBvxcqoQ7RlRv8GHPiQd fNgcjFUGXJidx5gZO7nS2c0HkipQaI1/nIq9FAWaDA5wYrYRJaNaNacs8aToWXHtvE503gP4f v57wyw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Wells Oliver schrieb am 19.04.2023 um 21:41: > I usually prefer pg_cancel_backend because it seems.. nicer, but > lately I've had a troublesome user who leaves transactions open and > I've scripted up a call to pg_terminate_backend after 60 minutes in > an idle transaction. It works well. Why don't you use the idle_in_transaction_session_timeout to do this automatically?