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 1oShfy-0007lX-Lh for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 16:31:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oShfw-0002RV-JI for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 16:31:48 +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 1oShfw-0002RL-6M for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:48 +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-0000XL-Q6 for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:46 +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=oztEis30iN12fkOWw/GV6YlUZ50IsvxG0EeOOVw1Qdg=; b=zSAI2eiA2l8D5hNrCeG49ZoG6P yJuc//UabmZ2nH8bZRKKEBXjbBEDEhM5CvhkGdb3hJLBDAIwmi4wCVcNgakwKe/1nPsFrfrd3T3Vc t1MUN5R8RKSoXepBkCSNXsQ763NwPZLXd7pOg7BsAXgoacn/BEgGHc49zYxbbU/Es9LJVM/pDI+8H iR6A/B4Kpij6RhiOaySz/QlzW1eRnGRpFlLoBGnQ+1wPw+W0JdJZqtgpVDvCQ3gQgHSuJA0HBIObh fJd+dsh/xOGsfHIvUUqu1lQpHXlbCxwgyTg5SKqQoWGL/DzrjwRsix2f0nogdHyTPoItgRLtQTCWw R6cAJ0xA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oShfr-0005bG-W0 for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:43 +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-000Tyw-Qa for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:43 +0000 Content-Type: multipart/mixed; boundary="===============1387448966856921899==" 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 --===============1387448966856921899== 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 Ci0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9lYjI5ZmEzODg5NWMwNjgxNGMzMGY3NTgxNjFhOTA1ZTY3 ZjAyZWQxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3Mv dHJhbnNhbS94bG9nLmMgICAgICAgICB8ICA4ICsrKysrKysrCnNyYy9iYWNrZW5kL2FjY2Vzcy90 cmFuc2FtL3hsb2dyZWNvdmVyeS5jIHwgMTYgKysrKysrKysrKystLS0tLQoyIGZpbGVzIGNoYW5n ZWQsIDE5IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgo= --===============1387448966856921899==--