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 1oShgt-0007nc-Ef for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 16:32:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oShgs-0005yc-8W for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 16:32:46 +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 1oShfy-0002o1-AI for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:50 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oShfs-0000XO-Uo for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=SQdRbPREMXll0PkwQM16zDKICUA54JAcy5gWbge4C6s=; b=fbDj/YKxMvDosBl1IX2DtJJ+Fv J2us+JgiLiEG/jxeVk+9zLAS7yzfTSQZIMIOC6dcElptDpMjKBK4ar/TrtcCe6MfCw8oISVpK2wE6 Gh/WoGAEIw31qKYJip5CrQcvmfwtC3P7sz5KfE8/x365yPCSjTfSvCHYerJi+Prrfsboc6zGVCUms HeeESpfg1o9WuFmpyeXaeAXbNjOSgg+gE2LUn2zD7OWtVCXqD8G1ah/QKVSzSf6KM3x4KB12T8yYi y1k2WudR9btMx/g3HCHzHBOW3A4joivOO4zs9p1pf9OsDqihBfLVBtrKMhFAbhldDGKtDRJPgNs5U 3L1nYlOg==; Received: from gemulon.postgresql.org ([72.32.157.198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oShfs-0005bK-Cg for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:44 +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 1oShfq-000Tz8-SV for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:43 +0000 Content-Type: multipart/mixed; boundary="===============6736253032600801199==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Prevent WAL corruption after a standby promotion. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Aug 2022 16:31:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6736253032600801199== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UHJldmVudCBXQUwgY29ycnVwdGlvbiBhZnRlciBhIHN0YW5kYnkgcHJvbW90aW9uLgoKV2hlbiBh IFBvc3RncmVTUUwgaW5zdGFuY2UgcGVyZm9ybWluZyBhcmNoaXZlIHJlY292ZXJ5IGJ1dCBub3Qg dXNpbmcKc3RhbmRieSBtb2RlIGlzIHByb21vdGVkLCBhbmQgdGhlIGxhc3QgV0FMIHNlZ21lbnQg dGhhdCBpdCBhdHRlbXB0ZWQKdG8gcmVhZCBlbmRlZCBpbiBhIHBhcnRpYWwgcmVjb3JkLCB0aGUg cHJldmlvdXMgY29kZSB3b3VsZCBjcmVhdGUKaW52YWxpZCBXQUwgb24gdGhlIG5ldyB0aW1lbGlu ZS4gVGhlIFdBTCBmcm9tIHRoZSBwcmV2aW91c2x5IHRpbWVsaW5lCndvdWxkIGJlIGNvcGllZCB0 byB0aGUgbmV3IHRpbWVsaW5lIHVwIHVudGlsIHRoZSBlbmQgb2YgdGhlIGxhc3QgdmFsaWQKcmVj b3JkLCBidXQgaW5zdGVhZCBvZiBiZWdpbm5pbmcgdG8gd3JpdGUgV0FMIGF0IGltbWVkaWF0ZWx5 CmFmdGVyd2FyZHMsIHRoZSBwcm9tb3RlZCBzZXJ2ZXIgd291bGQgd3JpdGUgYW4gb3ZlcndyaXRl IGNvbnRyZWNvcmQgYXQKdGhlIGJlZ2lubmluZyBvZiB0aGUgbmV4dCBzZWdtZW50LiBUaGUgZW5k IG9mIHRoZSBwcmV2aW91cyBzZWdtZW50CndvdWxkIGJlIGxlZnQgYXMgYWxsLXplcm9lcywgcmVz dWx0aW5nIGluIGZhaWx1cmVzIGlmIGFueXRoaW5nIHRyaWVkCnRvIHJlYWQgV0FMIGZyb20gdGhh dCBmaWxlLgoKVGhlIHJvb3Qgb2YgdGhlIGlzc3VlIGlzIHRoYXQgUmVhZFJlY29yZCgpIGRlY2lk ZXMgd2hldGhlciB0byBzZXQKYWJvcnRlZFJlY1B0ciBhbmQgbWlzc2luZ0NvbnRyZWNQdHIgYmFz ZWQgb24gdGhlIHZhbHVlIG9mIFN0YW5kYnlNb2RlLApidXQgUmVhZFJlY29yZCgpIHN3aXRjaGVz IHRvIGEgbmV3IHRpbWVsaW5lIGJhc2VkIG9uIHRoZSB2YWx1ZSBvZgpBcmNoaXZlUmVjb3ZlcnlS ZXF1ZXN0ZWQuIFdlIHNob3VsZG4ndCB0cnkgdG8gd3JpdGUgYW4gb3ZlcndyaXRlCmNvbnRyZWNv cmQgaWYgd2UncmUgc3dpdGNoaW5nIHRvIGEgbmV3IHRpbWVsaW5lLCBzbyBjaGFuZ2UgdGhlIHRl c3QgaW4KUmVhZFJlY29kKCkgdG8gY2hlY2sgQXJjaGl2ZVJlY292ZXJ5UmVxdWVzdGVkIGluc3Rl YWQuCgpDb2RlIGZpeCBieSBEaWxpcCBLdW1hci4gQ29tbWVudHMgYnkgbWUgaW5jb3Jwb3JhdGlu ZyBzdWdnZXN0ZWQKbGFuZ3VhZ2UgZnJvbSDDgWx2YXJvIEhlcnJlcmEuIEZ1cnRoZXIgcmV2aWV3 IGZyb20gS3lvdGFybyBIb3JpZ3VjaGkKYW5kIFNhbWkgSW1zZWloLgoKRGlzY3Vzc2lvbjogaHR0 cDovL3Bvc3Rnci5lcy9tL0NBRmlUTi10N3Vta2k9UEs4ZFQxdGNQVj1tT1VlMnZOaEhNTDZiM1Q3 VzdxcXZ2YWpqZ0BtYWlsLmdtYWlsLmNvbQpEaXNjdXNzaW9uOiBodHRwOi8vcG9zdGdyLmVzL20v RkIwREVBMEItRTE0RS00M0EwLTgxMUYtQzFBRTkzRDAwRkYzJTQwYW1hem9uLmNvbQoKQnJhbmNo Ci0tLS0tLQpSRUxfMTFfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8wMDJmYmE4MGViZGUxOWY5MDM1YzRmYmQ3YWJmMzExMWI4 ZDc1MzI2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3Mv dHJhbnNhbS94bG9nLmMgfCAyNCArKysrKysrKysrKysrKysrKysrLS0tLS0KMSBmaWxlIGNoYW5n ZWQsIDE5IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgo= --===============6736253032600801199==--