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 1nO0Fr-0006xS-94 for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Feb 2022 16:49:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nO0Fp-0007BH-1f for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Feb 2022 16:49:09 +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 1nO0Fo-0007B7-Oa for pgsql-hackers@lists.postgresql.org; Sat, 26 Feb 2022 16:49:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nO0Fl-0000pm-Rs for pgsql-hackers@lists.postgresql.org; Sat, 26 Feb 2022 16:49:07 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nO0Fj-0005nJ-2O for pgsql-hackers@lists.postgresql.org; Sat, 26 Feb 2022 16:49:03 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nO0Fi-0007S8-EX for pgsql-hackers@lists.postgresql.org; Sat, 26 Feb 2022 16:49:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file To: pgsql-hackers@lists.postgresql.org From: Chapman Flack Cc: David Steele , Nathan Bossart Date: Sat, 26 Feb 2022 16:48:52 +0000 User-Agent: pgcommitfest X-cfsender: chap In-Reply-To: <20220221172306.GA3698472@nathanxps13> References: <20220221172306.GA3698472@nathanxps13> Message-ID: <164589413251.1035.2695761148079719188.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBwYXNzZWQK SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIHBhc3NlZApTcGVjIGNvbXBsaWFudDog ICAgICAgICAgIG5vdCB0ZXN0ZWQKRG9jdW1lbnRhdGlvbjogICAgICAgICAgICBub3QgdGVzdGVk CgpUaGlzIHBhdGNoIGFwcGxpZXMgY2xlYW5seSBmb3IgbWUgYW5kIHBhc3NlcyBpbnN0YWxsY2hl Y2std29ybGQuDQpJIGhhdmUgbm90IHlldCBzdHVkaWVkIGFsbCBvZiB0aGUgY2hhbmdlcyBpbiBk ZXRhaWwuDQoNClNvbWUgcHJvb2ZyZWFkaW5nIG5pdHMgaW4gdGhlIGRvY3VtZW50YXRpb246IHRo ZSBwZ19zdG9wX2JhY2t1cA0Kd2l0aCBhcmd1bWVudHMgaGFzIGxvc3QgdGhlICdleGNsdXNpdmUn IGFyZ3VtZW50LCBidXQgc3RpbGwgc2hvd3MgYSBjb21tYQ0KYmVmb3JlIHRoZSAnd2FpdF9mb3Jf YXJjaGl2ZScgYXJndW1lbnQuIEFuZCB0aGUgbmlsYWRpYyBwZ19zdG9wX2JhY2t1cA0KaXMgc3Rp bGwgZG9jdW1lbnRlZCwgdGhvdWdoIGl0IG5vIGxvbmdlciBleGlzdHMuDQoNCk15IGJpZ2dlc3Qg Y29uY2VybnMgYXJlIHRoZSBjaGFuZ2VzIHRvIHRoZSBTUUwtdmlzaWJsZSBwZ19zdGFydF9iYWNr dXANCmFuZCBwZ19zdG9wX2JhY2t1cCBmdW5jdGlvbnMuIFdoZW4gdGhlIG5vbi1leGNsdXNpdmUg QVBJIHdhcyBpbXBsZW1lbnRlZA0KKGluIDcxMTc2ODUpLCB0aGF0IHdhcyBkb25lIHdpdGggY2Fy ZSAod2l0aCBhIG5ldyBvcHRpb25hbCBhcmd1bWVudCB0bw0KcGdfc3RhcnRfYmFja3VwLCBhbmQg YSBuZXcgb3ZlcmxvYWQgb2YgcGdfc3RvcF9iYWNrdXApIHRvIGF2b2lkIGltbWVkaWF0ZQ0KYnJl YWthZ2Ugb2Ygd29ya2luZyBiYWNrdXAgc2NyaXB0cy4NCg0KV2l0aCB0aGlzIHBhdGNoLCBldmVu IHNjcmlwdHMgdGhhdCB3ZXJlIGR1dGlmdWxseSBtaWdyYXRlZCB0byB0aGF0IG5ldyBBUEkgYW5k DQpub3cgaW52b2tlIHBnX3N0YXJ0X2JhY2t1cChsYWJlbCwgZmFsc2UpIG9yIChsYWJlbCwgZXhj bHVzaXZlID0+IGZhbHNlKSB3aWxsDQppbW1lZGlhdGVseSBhbmQgdW5uZWNlc3NhcmlseSBicmVh ay4gV2hhdCBJIHdvdWxkIHN1Z2dlc3QgZm9yIHRoaXMgcGF0Y2gNCndvdWxkIGJlIHRvIGNoYW5n ZSB0aGUgZXhjbHVzaXZlIGRlZmF1bHQgZnJvbSB0cnVlIHRvIGZhbHNlLCBhbmQgaGF2ZSB0aGUN CmZ1bmN0aW9uIHJlcG9ydCBhbiBFUlJPUiBpZiB0cnVlIGlzIHBhc3NlZC4NCg0KT3RoZXJ3aXNl LCBmb3Igc2l0ZXMgdXNpbmcgYSB0aGlyZC1wYXJ0eSBiYWNrdXAgc29sdXRpb24sIHRoZXJlIHdp bGwgYmUgYW4NCnVubmVjZXNzYXJ5IHJlcXVpcmVtZW50IHRvIHN5bmNocm9uaXplIGEgUG9zdGdy ZVNRTCB1cGdyYWRlIHdpdGggYW4NCnVwZ3JhZGUgb2YgdGhlIGJhY2t1cCBzb2x1dGlvbiB0aGF0 IHdvbid0IGJlIGJyb2tlbiBieSB0aGUgY2hhbmdlLiBGb3INCmEgc2l0ZSB3aXRoIHRoZWlyIGJh Y2t1cCBwcm9jZWR1cmVzIHNjcmlwdGVkIGluLWhvdXNlLCB0aGVyZSB3aWxsIGJlIGFuDQp1bm5l Y2Vzc2FyaWx5IHVyZ2VudCBuZWVkIGZvciB0aGUgY3VycmVudCBhZG1pbiB0ZWFtIHRvIHN0dWR5 IGFuZCBwYXRjaA0KdGhlIGN1cnJlbnRseS13b3JraW5nIHNjcmlwdHMuDQoNClRoYXQgY2FuIGJl IGF2b2lkZWQgYnkganVzdCBjaGFuZ2luZyB0aGUgZGVmYXVsdCB0byBmYWxzZSBhbmQgcmVqZWN0 aW5nIGNhbGxzDQp3aGVyZSB0cnVlIGlzIHBhc3NlZC4gVGhhdCB3aWxsIGJyZWFrIG9ubHkgc2Ny aXB0cyB0aGF0IG5ldmVyIGdvdCB0aGUgbWVtbw0KYWJvdXQgbW92aW5nIHRvIG5vbi1leGNsdXNp dmUgYmFja3VwLCBhdmFpbGFibGUgZm9yIHNpeCB5ZWFycyBub3cuDQoNCkFzc3VtaW5nIHRoZSB2 YWx1ZSBpcyBmYWxzZSwgc28gbm8gZXJyb3IgaXMgdGhyb3duLCBpcyBpdCBwcmFjdGljYWwgdG8g ZGV0ZXJtaW5lDQpmcm9tIGZsaW5mby0+Zm5fZXhwciB3aGV0aGVyIHRoZSB2YWx1ZSB3YXMgZGVm YXVsdGVkIG9yIHN1cHBsaWVkPyBJZiBzbywgSSB3b3VsZA0KZnVydGhlciBzdWdnZXN0IHJlcG9y dGluZyBhIGRlcHJlY2F0aW9uIFdBUk5JTkcgaWYgaXQgd2FzIGV4cGxpY2l0bHkgc3VwcGxpZWQs DQp3aXRoIGEgSElOVCB0aGF0IHRoZSBhcmd1bWVudCBjYW4gc2ltcGx5IGJlIHJlbW92ZWQgYXQg dGhlIGNhbGwgc2l0ZSwgYW5kIHdpbGwNCmJlY29tZSB1bnJlY29nbml6ZWQgaW4gc29tZSBmdXR1 cmUgcmVsZWFzZS4NCg0KcGdfc3RvcF9iYWNrdXAgbmVlZHMgdGhvdWdodCwgYmVjYXVzZSA3MTE3 Njg1IGFkZGVkIGEgbmV3IG92ZXJsb2FkIGZvciB0aGF0DQpmdW5jdGlvbiwgcmF0aGVyIHRoYW4g anVzdCBhbiBvcHRpb25hbCBhcmd1bWVudC4gVGhpcyBwYXRjaCByZW1vdmVzIHRoZSBvbGQNCm5p bGFkaWMgdmVyc2lvbiB0aGF0IHJldHVybmVkIHBnX2xzbiwgbGVhdmluZyBqdXN0IG9uZSB2ZXJz aW9uLCB3aXRoIGFuIG9wdGlvbmFsDQphcmd1bWVudCwgdGhhdCByZXR1cm5zIGEgcmVjb3JkLg0K DQpIZXJlIGFnYWluLCB0aGUgb2xkIG5pbGFkaWMgb25lIHdhcyBvbmx5IHN1aXRhYmxlIGZvciBl eGNsdXNpdmUgYmFja3Vwcywgc28gdGhlcmUNCmNhbid0IGJlIGFueSBzY3JpcHQgZXhpc3Rpbmcg aW4gMjAyMiB0aGF0IHN0aWxsIGNhbGxzIHRoYXQgdW5sZXNzIGl0IGhhcyBuZXZlciBiZWVuDQp1 cGRhdGVkIGluIHNpeCB5ZWFycyB0byBub25leGNsdXNpdmUgYmFja3VwcywgYW5kIHRoYXQgYnJl YWthZ2UgY2FuJ3QgYmUNCmhlbHBlZC4NCg0KQW55IHNjcmlwdHMgdGhhdCBkaWQgZ2V0IGR1dGlm dWxseSB1cGRhdGVkIG92ZXIgdGhlIGxhc3Qgc2l4IHllYXJzIHdpbGwgYmUgY2FsbGluZyB0aGUN CnJlY29yZC1yZXR1cm5pbmcgdmVyc2lvbiwgcGFzc2luZyBmYWxzZSwgb3IgZXhjbHVzaXZlID0+ IGZhbHNlLiBUaGlzIHBhdGNoIGFzIGl0DQpzdGFuZHMgd2lsbCB1bm5lY2Vzc2FyaWx5IGJyZWFr IHRob3NlLCBidXQgaGVyZSBhZ2FpbiBJIHRoaW5rIHRoYXQgY2FuIGJlIGF2b2lkZWQNCmp1c3Qg YnkgbWFraW5nIHRoZSBleGNsdXNpdmUgcGFyYW1ldGVyIG9wdGlvbmFsIHdpdGggZGVmYXVsdCBm YWxzZSwgYW5kIHJlcG9ydGluZw0KYW4gZXJyb3IgaWYgdHJ1ZSBpcyBwYXNzZWQuDQoNCkhlcmUg YWdhaW4sIEkgd291bGQgY29uc2lkZXIgYWxzbyBpc3N1aW5nIGEgZGVwcmVjYXRpb24gd2Fybmlu ZyBpZiB0aGUgYXJndW1lbnQNCmlzIGV4cGxpY2l0bHkgc3VwcGxpZWQsIGlmIGl0IGlzIHByYWN0 aWNhbCB0byBkZXRlcm1pbmUgdGhhdCBmcm9tIGZuX2V4cHIuIChJIGhhdmVuJ3QNCmxvb2tlZCB5 ZXQgdG8gc2VlIGhvdyBwcmFjdGljYWwgdGhhdCBpcy4pDQoNClJlZ2FyZHMsDQotQ2hhcA==