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 1n5dQj-00056V-7B for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jan 2022 00:48:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5dQh-0001dJ-D9 for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jan 2022 00:48:27 +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 1n5dQg-0001d9-Sq for pgsql-hackers@lists.postgresql.org; Fri, 07 Jan 2022 00:48:26 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n5dQe-0000Dj-I8 for pgsql-hackers@postgresql.org; Fri, 07 Jan 2022 00:48:25 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1641516504; x=1673052504; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=2gbfpCqnASfrg2aQHQ2o7XLlyzWwK4PTQdvxbQqpNSs=; b=a4D9EZFtTdJ4csPqREZ2Xmwp8Ve8Etn+fib9cXm0/AVFzKcrN0tkjTvU twyyabeTYUfmuSArlgn4YOYiX+hLmAns5LLrlBnLCDXaekiw4SRNfi4nH yl4NPeG+xIrRSU8QI4dfcGw9VjnTx6+UhaB8r/V8M2ePs1MivBk8Ppv0R k=; X-IronPort-AV: E=Sophos;i="5.88,268,1635206400"; d="scan'208";a="185409008" Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-pdx-2a-e6c05252.us-west-2.amazon.com) ([10.25.36.214]) by smtp-border-fw-9102.sea19.amazon.com with ESMTP; 07 Jan 2022 00:48:22 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-pdx-2a-e6c05252.us-west-2.amazon.com (Postfix) with ESMTPS id 6392D43157; Fri, 7 Jan 2022 00:48:22 +0000 (UTC) Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Fri, 7 Jan 2022 00:48:21 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Fri, 7 Jan 2022 00:48:21 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1497.026; Fri, 7 Jan 2022 00:48:21 +0000 From: "Bossart, Nathan" To: David Steele , Andrew Dunstan , Tom Lane CC: Stephen Frost , Laurenz Albe , Michael Paquier , Pg Hackers , SATYANARAYANA NARLAPURAM Subject: Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Thread-Topic: Postgres restart in the middle of exclusive backup and the presence of backup_label file Thread-Index: AQHX58RU5wbhXiIru0+iNdeRIL9iFqxWauMA Date: Fri, 7 Jan 2022 00:48:21 +0000 Message-ID: References: <417711.1637940660@sss.pgh.pa.us> <20211130142042.GR26257@tamriel.snowman.net> <3404870c1a921bafbcd168c098088981fe082ab1.camel@cybertec.at> <845544A4-0B0E-41D2-903C-C8B9E8A18812@amazon.com> <1661037.1638311167@sss.pgh.pa.us> <1cce9981-2c48-981a-a936-812830dfb3b1@pgmasters.net> <9427c6b3-5e0b-e27f-a2e7-ec1ebc00b582@pgmasters.net> <4a363c5a-473f-9cb9-9f59-74a230575340@dunslane.net> <553d2348-1015-3546-2be8-b5a8a745dfa8@pgmasters.net> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.160.37] Content-Type: text/plain; charset="utf-8" Content-ID: <001524CF406D0C45ADCA64127A9D2878@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTIvMi8yMSwgMTozNCBQTSwgIkJvc3NhcnQsIE5hdGhhbiIgPGJvc3NhcnRuQGFtYXpvbi5j b20+IHdyb3RlOg0KPiBPbiAxMi8yLzIxLCA5OjUwIEFNLCAiRGF2aWQgU3RlZWxlIiA8ZGF2aWRA cGdtYXN0ZXJzLm5ldD4gd3JvdGU6DQo+PiBPbiAxMi8yLzIxIDEyOjM4LCBEYXZpZCBTdGVlbGUg d3JvdGU6DQo+Pj4gT24gMTIvMi8yMSAxMTowMCwgQW5kcmV3IER1bnN0YW4gd3JvdGU6DQo+Pj4+ DQo+Pj4+IFNob3VsZCB3ZSByZWFsbHkgYmUgZ2V0dGluZyByaWQgb2YNCj4+Pj4gUG9zdGdyZVNR TDo6VGVzdDo6Q2x1c3Rlcjo6YmFja3VwX2ZzX2hvdCgpID8NCj4+Pg0KPj4+IEFncmVlZCwgaXQg d291bGQgYmUgYmV0dGVyIHRvIHVwZGF0ZSBiYWNrdXBfZnNfaG90KCkgdG8gdXNlIGV4Y2x1c2l2 ZQ0KPj4+IG1vZGUgYW5kIHNhdmUgb3V0IGJhY2t1cF9sYWJlbCBpbnN0ZWFkLg0KPj4NCj4+IE9v cHMsIG9mIGNvdXJzZSBJIG1lYW50IG5vbi1leGNsdXNpdmUgbW9kZS4NCj4NCj4gKzEuICBJJ2xs IGZpeCB0aGF0IGluIHRoZSBuZXh0IHJldmlzaW9uLg0KDQpJIGZpbmFsbHkgZ290IGFyb3VuZCB0 byBsb29raW5nIGludG8gdGhpcywgYW5kIEkgdGhpbmsgSSBmb3VuZCB3aHkgaXQNCndhcyBkb25l IHRoaXMgd2F5IGluIDIwMTguICBiYWNrdXBfZnNfaG90KCkgcnVucyBwZ19zdGFydF9iYWNrdXAo KSwNCmNsb3NlcyB0aGUgc2Vzc2lvbiwgY29waWVzIHRoZSBkYXRhLCBhbmQgdGhlbiBydW5zIHBn X3N0b3BfYmFja3VwKCkgaW4NCmEgZGlmZmVyZW50IHNlc3Npb24uICBUaGlzIGRvZXNuJ3Qgd29y ayB3aXRoIG5vbi1leGNsdXNpdmUgbW9kZQ0KYmVjYXVzZSB0aGUgYmFja3VwIHdpbGwgYmUgYWJv cnRlZCB3aGVuIHRoZSBzZXNzaW9uIHRoYXQgcnVucw0KcGdfc3RhcnRfYmFja3VwKCkgaXMgY2xv c2VkLiAgcGdfc3RvcF9iYWNrdXAoKSB3aWxsIGZhaWwgd2l0aCBhDQoiYmFja3VwIGlzIG5vdCBp biBwcm9ncmVzcyIgZXJyb3IuICBGdXJ0aGVybW9yZSwNCjAxMF9sb2dpY2FsX2RlY29kaW5nX3Rp bWVsaW5lcy5wbCBzZWVtcyB0byBiZSB0aGUgb25seSB0ZXN0IHRoYXQgdXNlcw0KYmFja3VwX2Zz X2hvdCgpLg0KDQpBZnRlciBhIHF1aWNrIGdsYW5jZSwgSSBkaWRuJ3Qgc2VlIGFuIGVhc3kgd2F5 IHRvIGhvbGQgYSBzZXNzaW9uIG9wZW4NCndoaWxlIHRoZSB0ZXN0IGRvZXMgb3RoZXIgdGhpbmdz LiAgSWYgdGhlcmUgaXNuJ3Qgb25lLCBtb2RpZnlpbmcNCmJhY2t1cF9mc19ob3QoKSB0byB3b3Jr IHdpdGggbm9uLWV4Y2x1c2l2ZSBtb2RlIG1pZ2h0IGJlIG1vcmUgdHJvdWJsZQ0KdGhhbiBpdCBp cyB3b3J0aC4NCg0KTmF0aGFuDQoNCg==