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 1oShgw-0007nb-Dj for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 16:32: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 1oShgs-0005yd-8W for pgsql-committers@arkaria.postgresql.org; Mon, 29 Aug 2022 16:32:46 +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 1oShfz-0003Uu-QS for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:51 +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 1oShft-0006Kx-Dg for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:51 +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=AtFZjnfQFUpVF6O+UP3Pz84HBdNpQNXQbsgHdo6ocJw=; b=L6DcwUijXkzfs6KFZQEHam+9Oz Kug6B9moBhiji4ADjvQWPGqYil6VZ2FjznAt2oOsTw2O+MqofM2GfEZ1BS7pYWC3GRdWkEo+/AAkC aNmE/gvi0Ct9WiiiPUYOnZv71ptUdoRONYfGC38bBEHmRMTB0RGZ1aBpHL//DASPGadPfg2MA0bGH c2dEvb0+ZFS4i97O1X/lKplSv6NBZ28brA6W01Z0kvfaUEYBujGxlAR0vnWB6MF6iM9btvS4TAkOL YjASl89R+QNMYPDd12yruC8APrt7SKCZ/XpvXdOSfGUXq5AHYMJd+06a75bUyU/cb2pem5HSu+ZZZ ffR9RrfA==; 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-0005bJ-Vz 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-000Tz5-S2 for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:43 +0000 Content-Type: multipart/mixed; boundary="===============1578234975577712441==" 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 --===============1578234975577712441== 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 Ci0tLS0tLQpSRUxfMTJfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zYzBlZjA4MzI3NDhmODAzMDgzOTJlMGFkODM4OGUxMzQ5 Y2NkNzc5CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3Mv dHJhbnNhbS94bG9nLmMgfCAyNCArKysrKysrKysrKysrKysrKysrLS0tLS0KMSBmaWxlIGNoYW5n ZWQsIDE5IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgo= --===============1578234975577712441==--