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 1scWq6-008Ax4-Hs for pgsql-committers@arkaria.postgresql.org; Fri, 09 Aug 2024 21:07:58 +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 1scWq5-0062j1-43 for pgsql-committers@arkaria.postgresql.org; Fri, 09 Aug 2024 21:07:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1scWq1-00620J-Nk for pgsql-committers@lists.postgresql.org; Fri, 09 Aug 2024 21:07:53 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1scWpy-0041qj-Sr for pgsql-committers@lists.postgresql.org; Fri, 09 Aug 2024 21:07:53 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1scWpx-00CFwU-AG for pgsql-committers@lists.postgresql.org; Fri, 09 Aug 2024 21:07:49 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1scWpw-003Tdn-4f for pgsql-committers@lists.postgresql.org; Fri, 09 Aug 2024 21:07:48 +0000 Content-Type: multipart/mixed; boundary="===============6238471069663524709==" MIME-Version: 1.0 From: Heikki Linnakangas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Refactor code to handle death of a backend or bgworker in postma X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 09 Aug 2024 21:07:48 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6238471069663524709== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVmYWN0b3IgY29kZSB0byBoYW5kbGUgZGVhdGggb2YgYSBiYWNrZW5kIG9yIGJnd29ya2VyIGlu IHBvc3RtYXN0ZXIKCkN1cnJlbnRseSwgd2hlbiBhIGNoaWxkIHByb2Nlc3MgZXhpdHMsIHRoZSBw b3N0bWFzdGVyIGZpcnN0IHNjYW5zCnRocm91Z2ggQmFja2dyb3VuZFdvcmtlckxpc3QsIHRvIHNl ZSBpZiBpdCB0aGUgY2hpbGQgcHJvY2VzcyB3YXMgYQpiYWNrZ3JvdW5kIHdvcmtlci4gSWYgbm90 IGZvdW5kLCB0aGVuIGl0IHNjYW5zIHRocm91Z2ggQmFja2VuZExpc3QgdG8Kc2VlIGlmIGl0IHdh cyBhIHJlZ3VsYXIgYmFja2VuZC4gVGhhdCBsZWFkcyB0byBzb21lIGR1cGxpY2F0aW9uCmJldHdl ZW4gdGhlIGJnd29ya2VyIGFuZCByZWd1bGFyIGJhY2tlbmQgY2xlYW51cCBjb2RlLCBhcyBib3Ro IGhhdmUgYW4KZW50cnkgaW4gdGhlIEJhY2tlbmRMaXN0IHRoYXQgbmVlZHMgdG8gYmUgY2xlYW5l ZCB1cCBpbiB0aGUgc2FtZSB3YXkuClJlZmFjdG9yIHRoYXQgc28gdGhhdCB3ZSBzY2FuIGp1c3Qg dGhlIEJhY2tlbmRMaXN0IHRvIGZpbmQgdGhlIGNoaWxkCnByb2Nlc3MsIGFuZCBpZiBpdCB3YXMg YSBiYWNrZ3JvdW5kIHdvcmtlciwgZG8gdGhlIGFkZGl0aW9uYWwKYmd3b3JrZXItc3BlY2lmaWMg Y2xlYW51cCBpbiBhZGRpdGlvbiB0byB0aGUgbm9ybWFsIEJhY2tlbmQgY2xlYW51cC4KCkNoYW5n ZSBIYW5kbGVDaGlsZENyYXNoIHNvIHRoYXQgaXQgZG9lc24ndCB0cnkgdG8gaGFuZGxlIHRoZSBj bGVhbnVwCm9mIHRoZSBwcm9jZXNzIHRoYXQgYWxyZWFkeSBleGl0ZWQsIG9ubHkgdGhlIHNpZ25h bGluZyBvZiBhbGwgdGhlCm90aGVyIHByb2Nlc3Nlcy4gV2hlbiBjYWxsZWQgZm9yIGFueSBvZiB0 aGUgYXV4IHByb2Nlc3NlcywgdGhlIGNhbGxlcgpoYWQgYWxyZWFkeSBjbGVhcmVkIHRoZSAqUElE IGdsb2JhbCB2YXJpYWJsZSwgc28gdGhlIGNvZGUgaW4KSGFuZGxlQ2hpbGRDcmFzaCgpIHRvIGRv IHRoYXQgd2FzIHVudXNlZC4KCk9uIFdpbmRvd3MsIGlmIGEgY2hpbGQgcHJvY2VzcyBleGl0cyB3 aXRoIEVSUk9SX1dBSVRfTk9fQ0hJTERSRU4sIGl0J3MKbm93IGxvZ2dlZCB3aXRoIHRoYXQgZXhp dCBjb2RlLCBpbnN0ZWFkIG9mIDAuIEFsc28sIGlmIGEgYmd3b3JrZXIKZXhpdHMgd2l0aCBFUlJP Ul9XQUlUX05PX0NISUxEUkVOLCBpdCdzIG5vdyB0cmVhdGVkIGFzIGNyYXNoZWQgYW5kIGlzCnJl c3RhcnRlZC4gUHJldmlvdXNseSBpdCB3YXMgdHJlYXRlZCBhcyBhIG5vcm1hbCBleGl0LgoKSWYg YSBjaGlsZCBwcm9jZXNzIGlzIG5vdCBmb3VuZCBpbiB0aGUgQmFja2VuZExpc3QsIHRoZSBsb2cg bWVzc2FnZQpub3cgY2FsbHMgaXQgInVudHJhY2tlZCBjaGlsZCBwcm9jZXNzIiByYXRoZXIgdGhh biAic2VydmVyIHByb2Nlc3MiLgpBcmd1YWJseSB0aGF0IHNob3VsZCBiZSBhIFBBTklDLCBiZWNh dXNlIHdlIGRvIHRyYWNrIGFsbCB0aGUgY2hpbGQKcHJvY2Vzc2VzIGluIHRoZSBsaXN0LCBzbyBm YWlsaW5nIHRvIGZpbmQgYSBjaGlsZCBwcm9jZXNzIGlzIGhpZ2hseQp1bmV4cGVjdGVkLiBCdXQg aWYgd2Ugd2FudCB0byBjaGFuZ2UgdGhhdCwgbGV0J3MgZGlzY3VzcyBhbmQgZG8gdGhhdAphcyBh IHNlcGFyYXRlIGNvbW1pdC4KClJldmlld2VkLWJ5OiBUaG9tYXMgTXVucm8gPHRob21hcy5tdW5y b0BnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3Nh Z2UtaWQvODM1MjMyYzAtYTVmNy00ZjIwLWI5NWItNWI1NmJhNTdkNzQxQGlraS5maQoKQnJhbmNo Ci0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmLzI4YTUyMGMwYjc3MzI1YTk3YmFmZDBmNTdjYzdiZDBkZDUyM2I3MWUK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYmd3 b3JrZXIuYyAgICAgICAgICAgfCAgIDQgLQpzcmMvYmFja2VuZC9wb3N0bWFzdGVyL3Bvc3RtYXN0 ZXIuYyAgICAgICAgIHwgNDM5ICsrKysrKysrKysrLS0tLS0tLS0tLS0tLS0tLS0Kc3JjL2luY2x1 ZGUvcG9zdG1hc3Rlci9iZ3dvcmtlcl9pbnRlcm5hbHMuaCB8ICAgNyArLQozIGZpbGVzIGNoYW5n ZWQsIDE3MCBpbnNlcnRpb25zKCspLCAyODAgZGVsZXRpb25zKC0pCgo= --===============6238471069663524709==--