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-0007nd-El 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-0005ya-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 1oShfw-0002RM-PJ 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-0000XM-PZ for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:47 +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=LvpnR8ZJoQu4tJI2DCGZ/Hp7XE7mg6Lfje+AOVy+qjE=; b=KUNStzKmtqTHSw/GLq2czuYd1Q L7o/MqsLXGXWBd4PhjJidsaQHUkjE2CYMiGEnYFN/2DiLdcxHq3oyfVqBOShadSYqoYbecxiqdRNX PtOh3GTLGPAx/KDXxH6JhlGtI2iVy1bFUUOf9v4/A/85sHC5D+9sMOTqVmqexBCE8fpI+EX/e3hhl m2BJOHq1h9MIYMLo55rRF+EGbkipJxOprSJGk11f9j4EzSIXGrokTPmo3Ugz4BNGetFZPpjW3j1Iy EV8k9YOvuYKGXTb7J/Wwyf4/gwVvWoSGTfP///jGA7VWJxWaABgA5qgrJ09RqcBWThuTV4uBtjxkZ 4VqjsduA==; 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-0005bI-Uo 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-000Tz1-RX for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:43 +0000 Content-Type: multipart/mixed; boundary="===============8293416783482318474==" 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 --===============8293416783482318474== 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 Ci0tLS0tLQpSRUxfMTNfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zZjI3MDFjZGE1OTBkODI1MGE3NDVkNDBmNzBkYmViNThh NjA2YmU4CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3Mv dHJhbnNhbS94bG9nLmMgfCAyNCArKysrKysrKysrKysrKysrKysrLS0tLS0KMSBmaWxlIGNoYW5n ZWQsIDE5IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgo= --===============8293416783482318474==--