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-0007nb-ER 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-0005yf-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 1oShg0-0003lp-I8 for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:52 +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-0006Kz-IY for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:52 +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=MWxWqKiAkNjv1ohe2vLY9+2uTQvO1N+G6EccZN6x9q0=; b=NXUUqscG3d9eHo4YFca23vZJFk 9arBgjiK4ftYGmxsHrrPEvqDliXEmL7IvKwPpylTJ6Z4CdfKx60i2jxlcNTJMKUr5q0KLBR7EZjpC WbYiX0ezPRyTd+75Pi+vv7JK1pGXvj3LiPT8iRB2PqpN4dMItTvUyc5I/pa+XDtNJDpdPt+jW/7+t t6U6KSUJsYbFPwQR8E0skTENc6QWz0JGVNA29NBoexkUaCgD04g/UeRlaD3h5slcE1nXvM9o+rg0H CDyl0B3GfWVdYE/emVCGrdlcGRnUsMv17RdggfoPkSL3HCKHaOcWotYJu7cr/aeC2gZ9VQtXcq9Pp mfY0BMaw==; 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-0005bL-Ck 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-000TzB-T4 for pgsql-committers@lists.postgresql.org; Mon, 29 Aug 2022 16:31:43 +0000 Content-Type: multipart/mixed; boundary="===============2315643796566080745==" 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 --===============2315643796566080745== 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 Ci0tLS0tLQpSRUxfMTBfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8wYjNmZjUzOWRkMzQxYjUyYjY5N2M1MzVhYWU0YzI3MDA1 MmY3ZThlCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3Mv dHJhbnNhbS94bG9nLmMgfCAyNCArKysrKysrKysrKysrKysrKysrLS0tLS0KMSBmaWxlIGNoYW5n ZWQsIDE5IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgo= --===============2315643796566080745==--