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 1ppDq1-0000Dq-KR for pgsql-admin@arkaria.postgresql.org; Wed, 19 Apr 2023 19:51:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppDq0-0007G1-KZ for pgsql-admin@arkaria.postgresql.org; Wed, 19 Apr 2023 19:51:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppDpz-0007Fs-EZ for pgsql-admin@lists.postgresql.org; Wed, 19 Apr 2023 19:51:32 +0000 Received: from mx0a-000e5c14.pphosted.com ([148.163.133.209]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ppDpt-003t8V-6Y for pgsql-admin@postgresql.org; Wed, 19 Apr 2023 19:51:29 +0000 Received: from pps.filterd (m0206225.ppops.net [127.0.0.1]) by mx0a-000e5c14.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 33JBTg8A010148; Wed, 19 Apr 2023 14:51:20 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=express-scripts.com; h=from : to : date : message-id : references : in-reply-to : content-type : mime-version : subject; s=pod140124231234; bh=DhIMvv+CMaXj39KMFZH95cgesouDtnjI6OYhi2J8OCQ=; b=J6sbZVOwxBz1FgDZ4CuHJGxrmCZCPq+8TUMqbw4Ezf86dLVazMCeMRfvbiVP+FBiDafC MoRW5ygvSI4+i8EyLP7Bjp6kfMKuNOqR0WBP6IjMrzmFoEi6QZEGjxxnaHx9iFW4WQof HNZQfHY39Or4GvbsXXmznh3XgpumEx0Fq9+zSRQ5La7H51wD+GCCxLMVTby5QqURnPB4 Rt5ik6iR0/iePN3aEHbz/jphUUuwBJqtFfzAMA2tz3MDcDOEBhlo0+lYXycGcHT5VYyb MrUAfP+VDGWSrI+N7h4TgGu9BSim48dgCndHq4/z5CQ9i6L5twVunEDjwAYNCGrA/GfV Ew== Received: from eiaappxp0008.gid.prd.globalcore.com ([170.48.0.131]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3pyr7qrhs8-4 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 19 Apr 2023 14:51:20 -0500 Received: from cvlappxp20749.internal.cigna.com (HELO PS2PW1012186.accounts.root.corp) ([10.36.52.79]) by EIAAPPXP0008.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 19 Apr 2023 19:51:18 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012186.accounts.root.corp (10.221.225.154) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.26; Wed, 19 Apr 2023 15:51:17 -0400 Received: from PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad]) by PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad%6]) with mapi id 15.02.1118.026; Wed, 19 Apr 2023 15:51:17 -0400 From: "Wetmore, Matthew (CTR)" To: Wells Oliver , pgsql-admin Thread-Topic: [EXTERNAL] pg_cancel_backend and pg_terminate_backend Thread-Index: AQHZcvcZVv29Yer+UUC7e3lss1gB268zCqSQ Date: Wed, 19 Apr 2023 19:51:17 +0000 Message-ID: <83b2ee4970954aebb6dbe7d8f5f6e87b@express-scripts.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.221.252.1] x-proofpoint-routing: 000e5c14 Content-Type: multipart/alternative; boundary="_000_83b2ee4970954aebb6dbe7d8f5f6e87bexpressscriptscom_" MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: pg_cancel_backend and pg_terminate_backend X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.254,Aquarius:18.0.942,Hydra:6.0.573,FMLib:17.11.170.22 definitions=2023-04-19_14,2023-04-18_01,2023-02-09_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_83b2ee4970954aebb6dbe7d8f5f6e87bexpressscriptscom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 cGdfY2FuY2VsX2JhY2tlbmQoKQ0KQSBmdW5jdGlvbiB3aGljaCBjYW5jZWxzIGEgYmFja2VuZCdz IGN1cnJlbnQgcXVlcnkNCg0KcGdfdGVybWluYXRlX2JhY2tlbmQoKQ0KQSBmdW5jdGlvbiB3aGlj aCBpbnN0cnVjdHMgYSBiYWNrZW5kIHRvIHRlcm1pbmF0ZQ0KDQpGcm9tOiBXZWxscyBPbGl2ZXIg PHdlbGxzLm9saXZlckBnbWFpbC5jb20+DQpTZW50OiBXZWRuZXNkYXksIEFwcmlsIDE5LCAyMDIz IDI6NDIgUE0NClRvOiBwZ3NxbC1hZG1pbiA8cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmc+DQpT dWJqZWN0OiBbRVhURVJOQUxdIHBnX2NhbmNlbF9iYWNrZW5kIGFuZCBwZ190ZXJtaW5hdGVfYmFj a2VuZA0KDQpJIHVzdWFsbHkgcHJlZmVyIHBnX2NhbmNlbF9iYWNrZW5kIGJlY2F1c2UgaXQgc2Vl bXMuLiBuaWNlciwgYnV0IGxhdGVseSBJJ3ZlIGhhZCBhIHRyb3VibGVzb21lIHVzZXIgd2hvIGxl YXZlcyB0cmFuc2FjdGlvbnMgb3BlbiBhbmQgSSd2ZSBzY3JpcHRlZCB1cCBhIGNhbGwgdG8gcGdf dGVybWluYXRlX2JhY2tlbmQgYWZ0ZXIgNjAgbWludXRlcyBpbiBhbiBpZGxlIHRyYW5zYWN0aW9u LiBJdCB3b3JrcyB3ZWxsLg0KDQpRdWVzdGlvbjogaXMgdGhlcmUgYW55IHNlcnZlciBpbXBhY3Qg YmV5b25kIHRoYXQgdXNlcidzIHRyYW5zYWN0aW9uIHdoZW4gY2FsbGluZyBwZ190ZXJtaW5hdGVf YmFja2VuZD8gSSBmZWVsIGxpa2UgdGhlcmUgX3VzZWRfIHRvIGJlLCBtYXliZSBpbiBQRzksIHdo ZXJlIEkgcmVjYWxsIG1heWJlIHNlZWluZyBhIHNlcnZlciBkaXNjb25uZWN0IG9yIHNvbWV0aGlu ZyB3aGVuIHVzaW5nIHRlcm1pbmF0ZS4NCg0KSnVzdCBjdXJpb3VzIGFib3V0IHRoaXMgYXBwcm9h Y2guIFRoYW5rcy4NCg0KLS0NCldlbGxzIE9saXZlcg0Kd2VsbHMub2xpdmVyQGdtYWlsLmNvbTxt YWlsdG86d2VsbHNvbGl2ZXJAZ21haWwuY29tPg0K --_000_83b2ee4970954aebb6dbe7d8f5f6e87bexpressscriptscom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjpibHVlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBzcGFu Lk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xvcjpw dXJwbGU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpwLm1zb25vcm1hbDAsIGxpLm1z b25vcm1hbDAsIGRpdi5tc29ub3JtYWwwDQoJe21zby1zdHlsZS1uYW1lOm1zb25vcm1hbDsNCglt c28tbWFyZ2luLXRvcC1hbHQ6YXV0bzsNCgltYXJnaW4tcmlnaHQ6MGluOw0KCW1zby1tYXJnaW4t Ym90dG9tLWFsdDphdXRvOw0KCW1hcmdpbi1sZWZ0OjBpbjsNCglmb250LXNpemU6MTIuMHB0Ow0K CWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLHNlcmlmO30NCnNwYW4uZ21haWxzaWduYXR1 cmVwcmVmaXgNCgl7bXNvLXN0eWxlLW5hbWU6Z21haWxfc2lnbmF0dXJlX3ByZWZpeDt9DQpzcGFu LkVtYWlsU3R5bGUxOQ0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZh bWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZh dWx0DQoJe21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmO30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsN CgltYXJnaW46MS4waW4gMS4waW4gMS4waW4gMS4waW47fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtw YWdlOldvcmRTZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0K PG86c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwh W2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9 ImVkaXQiPg0KPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlv dXQ+PC94bWw+PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1VUyIgbGluaz0i Ymx1ZSIgdmxpbms9InB1cnBsZSI+DQo8ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0QiPnBnX2NhbmNlbF9i YWNrZW5kKCk8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3Bh biBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7 LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+QSBmdW5jdGlvbiB3aGljaCBjYW5jZWxzIGEgYmFj a2VuZCdzIGN1cnJlbnQgcXVlcnk8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNv Tm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtD YWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48 L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTox MS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMx RjQ5N0QiPnBnX3Rlcm1pbmF0ZV9iYWNrZW5kKCk8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWls eTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+QSBmdW5jdGlv biB3aGljaCBpbnN0cnVjdHMgYSBiYWNrZW5kIHRvIHRlcm1pbmF0ZTxvOnA+PC9vOnA+PC9zcGFu PjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0 O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdE Ij48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48Yj48 c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1 b3Q7LHNhbnMtc2VyaWYiPkZyb206PC9zcGFuPjwvYj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEx LjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWYiPiBXZWxscyBP bGl2ZXIgJmx0O3dlbGxzLm9saXZlckBnbWFpbC5jb20mZ3Q7DQo8YnI+DQo8Yj5TZW50OjwvYj4g V2VkbmVzZGF5LCBBcHJpbCAxOSwgMjAyMyAyOjQyIFBNPGJyPg0KPGI+VG86PC9iPiBwZ3NxbC1h ZG1pbiAmbHQ7cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcmZ3Q7PGJyPg0KPGI+U3ViamVjdDo8 L2I+IFtFWFRFUk5BTF0gcGdfY2FuY2VsX2JhY2tlbmQgYW5kIHBnX3Rlcm1pbmF0ZV9iYWNrZW5k PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8 L286cD48L3A+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SSB1c3VhbGx5IHByZWZlciZu YnNwO3BnX2NhbmNlbF9iYWNrZW5kIGJlY2F1c2UgaXQgc2VlbXMuLiBuaWNlciwgYnV0IGxhdGVs eSBJJ3ZlIGhhZCBhIHRyb3VibGVzb21lIHVzZXIgd2hvIGxlYXZlcyB0cmFuc2FjdGlvbnMgb3Bl biBhbmQgSSd2ZSBzY3JpcHRlZCB1cCBhIGNhbGwgdG8mbmJzcDtwZ190ZXJtaW5hdGVfYmFja2Vu ZCBhZnRlciA2MCBtaW51dGVzIGluIGFuIGlkbGUgdHJhbnNhY3Rpb24uIEl0IHdvcmtzIHdlbGwu PG86cD48L286cD48L3A+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8 L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5RdWVzdGlvbjog aXMgdGhlcmUgYW55IHNlcnZlciBpbXBhY3QgYmV5b25kIHRoYXQgdXNlcidzIHRyYW5zYWN0aW9u IHdoZW4gY2FsbGluZyBwZ190ZXJtaW5hdGVfYmFja2VuZD8gSSBmZWVsIGxpa2UgdGhlcmUgX3Vz ZWRfIHRvIGJlLCBtYXliZSBpbiBQRzksIHdoZXJlIEkgcmVjYWxsIG1heWJlIHNlZWluZyBhIHNl cnZlciBkaXNjb25uZWN0IG9yIHNvbWV0aGluZyZuYnNwO3doZW4gdXNpbmcgdGVybWluYXRlLjxv OnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4m bmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5KdXN0 IGN1cmlvdXMgYWJvdXQgdGhpcyBhcHByb2FjaC4gVGhhbmtzLjxvOnA+PC9vOnA+PC9wPg0KPC9k aXY+DQo8ZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+ PC9wPg0KPC9kaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBjbGFzcz0iZ21haWxzaWdu YXR1cmVwcmVmaXgiPi0tIDwvc3Bhbj48bzpwPjwvbzpwPjwvcD4NCjxkaXY+DQo8ZGl2Pg0KPGRp dj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPldlbGxzIE9saXZlcjxicj4NCjxhIGhyZWY9Im1haWx0 bzp3ZWxsc29saXZlckBnbWFpbC5jb20iIHRhcmdldD0iX2JsYW5rIj53ZWxscy5vbGl2ZXJAZ21h aWwuY29tPC9hPjxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+ DQo8L2Rpdj4NCjwvZGl2Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_83b2ee4970954aebb6dbe7d8f5f6e87bexpressscriptscom_--