Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVMlQ-0012UQ-1d for pgsql-committers@arkaria.postgresql.org; Tue, 16 Dec 2025 04:34:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVMlP-0044EV-0l for pgsql-committers@arkaria.postgresql.org; Tue, 16 Dec 2025 04:34:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVMiK-0041xD-2G for pgsql-committers@lists.postgresql.org; Tue, 16 Dec 2025 04:31:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVMiI-000z1g-2z for pgsql-committers@lists.postgresql.org; Tue, 16 Dec 2025 04:31:09 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVMiI-002ji7-0k for pgsql-committers@lists.postgresql.org; Tue, 16 Dec 2025 04:31:05 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVMiB-0010m7-1k for pgsql-committers@lists.postgresql.org; Tue, 16 Dec 2025 04:31:00 +0000 Content-Type: multipart/mixed; boundary="===============5351641486714044747==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fail recovery when missing redo checkpoint record without backup X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 16 Dec 2025 04:31:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5351641486714044747== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RmFpbCByZWNvdmVyeSB3aGVuIG1pc3NpbmcgcmVkbyBjaGVja3BvaW50IHJlY29yZCB3aXRob3V0 IGJhY2t1cF9sYWJlbAoKVGhpcyBjb21taXQgYWRkcyBhbiBleHRyYSBjaGVjayBhdCB0aGUgYmVn aW5uaW5nIG9mIHJlY292ZXJ5IHRvIGVuc3VyZQp0aGF0IHRoZSByZWRvIHJlY29yZCBvZiBhIGNo ZWNrcG9pbnQgZXhpc3RzIGJlZm9yZSBhdHRlbXB0aW5nIFdBTApyZXBsYXksIGxvZ2dpbmcgYSBQ QU5JQyBpZiB0aGUgcmVkbyByZWNvcmQgcmVmZXJlbmNlZCBieSB0aGUgY2hlY2twb2ludApyZWNv cmQgY291bGQgbm90IGJlIGZvdW5kLiAgVGhpcyBpcyB0aGUgc2FtZSBsZXZlbCBvZiBmYWlsdXJl IGFzIHdoZW4gYQpjaGVja3BvaW50IHJlY29yZCBpcyBtaXNzaW5nLiAgVGhpcyBjaGVjayBpcyBh ZGRlZCB3aGVuIGEgY2x1c3RlciBpcwpzdGFydGVkIHdpdGhvdXQgYSBiYWNrdXBfbGFiZWwsIGFm dGVyIHJldHJpZXZpbmcgaXRzIGNoZWNrcG9pbnQgcmVjb3JkLgpUaGUgcmVkbyBMU04gdXNlZCBm b3IgdGhlIGNoZWNrIGlzIHJldHJpZXZlZCBmcm9tIHRoZSBjaGVja3BvaW50IHJlY29yZApzdWNj ZXNzZnVsbHkgcmVhZC4KCkluIHRoZSBjYXNlIHdoZXJlIGEgYmFja3VwX2xhYmVsIGV4aXN0cywg dGhlIHN0YXJ0dXAgcHJvY2VzcyBhbHJlYWR5CmZhaWxzIGlmIHRoZSByZWRvIHJlY29yZCBjYW5u b3QgYmUgZm91bmQgYWZ0ZXIgcmVhZGluZyBhIGNoZWNrcG9pbnQKcmVjb3JkIGF0IHRoZSBiZWdp bm5pbmcgb2YgcmVjb3ZlcnkuCgpQcmV2aW91c2x5LCB0aGUgcHJlc2VuY2Ugb2YgdGhlIHJlZG8g cmVjb3JkIHdhcyBub3QgY2hlY2tlZC4gIElmIHRoZQpyZWRvIGFuZCBjaGVja3BvaW50IHJlY29y ZHMgd2VyZSBsb2NhdGVkIG9uIGRpZmZlcmVudCBXQUwgc2VnbWVudHMsIGl0CndvdWxkIGJlIHBv c3NpYmxlIHRvIG1pc3MgYSBlbnRpcmUgcmFuZ2Ugb2YgV0FMIHJlY29yZHMgdGhhdCBzaG91bGQg aGF2ZQpiZWVuIHJlcGxheWVkIGJ1dCB3ZXJlIGp1c3QgaWdub3JlZC4gIFRoZSBjb25zZXF1ZW5j ZXMgb2YgbWlzc2luZyB0aGUKcmVkbyByZWNvcmQgZGVwZW5kIG9uIHRoZSB2ZXJzaW9uIGRlYWx0 IHdpdGgsIHRoZXNlIGJlY29taW5nIHdvcnNlIHRoZQpvbGRlciB0aGUgdmVyc2lvbiB1c2VkOgot IE9uIEhFQUQsIHYxOCBhbmQgdjE3LCByZWNvdmVyeSBmYWlscyB3aXRoIGEgcG9pbnRlciBkZXJl ZmVyZW5jZSBhdCB0aGUKYmVnaW5uaW5nIG9mIHRoZSByZWRvIGxvb3AsIGFzIHRoZSByZWRvIHJl Y29yZCBpcyBleHBlY3RlZCBidXQgY2Fubm90IGJlCmZvdW5kLiAgVGhlc2UgdmVyc2lvbnMgYXJl IGdvb2Qgc3R1ZGVudHMsIGJlY2F1c2Ugd2UgZGV0ZWN0IGEgZmFpbHVyZQpiZWZvcmUgZG9pbmcg YW55dGhpbmcsIGV2ZW4gaWYgdGhlIGZhaWx1cmUgaXMgbWlzbGVhZGluZyBpbiB0aGUgc2hhcGUg b2YKYSBzZWdtZW50YXRpb24gZmF1bHQsIGdpdmluZyBubyBpbmZvcm1hdGlvbiB0aGF0IHRoZSBy ZWRvIHJlY29yZCBpcwptaXNzaW5nLgotIEluIHYxNiBhbmQgdjE1LCBwcm9ibGVtcyBzaG93IGF0 IHRoZSBlbmQgb2YgcmVjb3Zlcnkgd2l0aGluCkZpbmlzaFdhbFJlY292ZXJ5KCksIHRoZSBzdGFy dHVwIHByb2Nlc3MgdXNpbmcgYSBidWdneSBMU04gdG8gZGVjaWRlCmZyb20gd2hlcmUgdG8gc3Rh cnQgd3JpdGluZyBXQUwuICBUaGUgY2x1c3RlciBnZXRzIGNvcnJ1cHRlZCwgc3RpbGwgaXQKaXMg bm9pc3kgYWJvdXQgaXQuCi0gdjE0IGFuZCBvbGRlciB2ZXJzaW9ucyBhcmUgd29yc2U6IGEgY2x1 c3RlciBnZXRzIGNvcnJ1cHRlZCBidXQgaXQgaXMKZW50aXJlbHkgc2lsZW50IGFib3V0IHRoZSBt YXR0ZXIuICBUaGUgcmVkbyByZWNvcmQgbWlzc2luZyBjYXVzZXMgdGhlCnN0YXJ0dXAgcHJvY2Vz cyB0byBza2lwIGVudGlyZWx5IHJlY292ZXJ5LCBiZWNhdXNlIGEgbWlzc2luZyByZWNvcmQgaXMK dGhlIHNhbWUgYXMgbm90IHJlZG8gYmVpbmcgcmVxdWlyZWQgYXQgYWxsLiAgVGhpcyBsZWFkcyB0 byBkYXRhIGxvc3MsIGFzCmV2ZXJ5dGhpbmcgaXMgbWlzc2VkIGJldHdlZW4gdGhlIHJlZG8gcmVj b3JkIGFuZCB0aGUgY2hlY2twb2ludCByZWNvcmQuCgpOb3RlIHRoYXQgSSBoYXZlIHRlc3RlZCB0 aGF0IGRvd24gdG8gOS40LCByZXByb2R1Y2luZyB0aGUgaXNzdWUgd2l0aCBhCnZlcnNpb24gb2Yg dGhlIGF1dGhvcidzIHJlcHJvZHVjZXIgc2xpZ2h0bHkgbW9kaWZpZWQuICBUaGUgY29kZSBpcyB3 cm9uZwpzaW5jZSBhdCBsZWFzdCA5LjIsIGJ1dCBJIGRpZCBub3QgbG9vayBhdCB0aGUgZXhhY3Qg cG9pbnQgb2Ygb3JpZ2luLgoKVGhpcyBwcm9ibGVtIGhhcyBiZWVuIGZvdW5kIGJ5IGRlYnVnZ2lu ZyBhIGNsdXN0ZXIgd2hlcmUgdGhlIFdBTCBzZWdtZW50CmluY2x1ZGluZyB0aGUgcmVkbyBzZWdt ZW50IHdhcyBtaXNzaW5nIGR1ZSB0byBhbiBvcGVyYXRvciBlcnJvciwgbGVhZGluZwp0byBhIGNy YXNoLCBiYXNlZCBvbiBhbiBpbnZlc3RpZ2F0aW9uIGluIHYxNS4KClJlcXVlc3RpbmcgYXJjaGl2 ZSByZWNvdmVyeSB3aXRoIHRoZSBjcmVhdGlvbiBvZiBhIHJlY292ZXJ5LnNpZ25hbCBvcgphIHN0 YW5kYnkuc2lnbmFsIGV2ZW4gd2l0aG91dCBhIGJhY2t1cF9sYWJlbCB3b3VsZCBtaXRpZ2F0ZSB0 aGUgaXNzdWU6CmlmIHRoZSByZWNvcmQgY2Fubm90IGJlIGZvdW5kIGluIHBnX3dhbC8sIHRoZSBt aXNzaW5nIHNlZ21lbnQgY2FuIGJlCnJldHJpZXZlZCB3aXRoIGEgcmVzdG9yZV9jb21tYW5kIHdo ZW4gY2hlY2tpbmcgdGhhdCB0aGUgcmVkbyByZWNvcmQKZXhpc3RzLiAgVGhpcyB3YXMgYWxyZWFk eSB0aGUgY2FzZSB3aXRob3V0IHRoaXMgY29tbWl0LCB3aGVyZSByZWNvdmVyeQp3b3VsZCByZS1m ZXRjaCB0aGUgV0FMIHNlZ21lbnQgdGhhdCBpbmNsdWRlcyB0aGUgcmVkbyByZWNvcmQuICBUaGUg Y2hlY2sKaW50cm9kdWNlZCBieSB0aGlzIGNvbW1pdCBtYWtlcyB0aGUgc2VnbWVudCB0byBiZSBy ZXRyaWV2ZWQgZWFybGllciB0bwptYWtlIHN1cmUgdGhhdCB0aGUgcmVkbyByZWNvcmQgY2FuIGJl IGZvdW5kLgoKT24gSEVBRCwgdGhlIGNvZGUgd2lsbCBiZSBzbGlnaHRseSBjaGFuZ2VkIGluIGEg Zm9sbG93LXVwIGNvbW1pdCB0byBub3QKcmVseSBvbiBhIFBBTklDLCB0byBpbmNsdWRlIGEgdGVz dCBhYmxlIHRvIGVtdWxhdGUgdGhlIG9yaWdpbmFsIHByb2JsZW0uClRoaXMgaXMgYSBtaW5pbWFs IGJhY2twYXRjaGFibGUgZml4LCBrZXB0IHNlcGFyYXRlZCBmb3IgY2xhcml0eS4KClJlcG9ydGVk LWJ5OiBBbmRyZXMgRnJldW5kIDxhbmRyZXNAYW5hcmF6ZWwuZGU+CkFuYWx5emVkLWJ5OiBBbmRy ZXMgRnJldW5kIDxhbmRyZXNAYW5hcmF6ZWwuZGU+CkF1dGhvcjogTml0aW4gSmFkaGF2IDxuaXRp bmphZGhhdnBvc3RncmVzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMv bS8yMDIzMTAyMzIzMjE0NS5jbXFlNzNzdHZpdnNtbGhzQGF3b3JrMy5hbmFyYXplbC5kZQpEaXNj dXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBTW0xYVdhYUppMnc0OWMwUmlhREJmaGRDTDZ6 dGJyOW09ZGFHcWlPdVZkaXpZV1lhQUBtYWlsLmdtYWlsLmNvbQpCYWNrcGF0Y2gtdGhyb3VnaDog MTQKCkJyYW5jaAotLS0tLS0KUkVMXzE4X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNjhlYmRmMmIwN2Y2ZmIyZDgzZjZlNjQ0 MDMxMGZkYjRiNzM3N2JiMwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvYWNjZXNzL3RyYW5zYW0veGxvZ3JlY292ZXJ5LmMgfCAxMCArKysrKysrKysrCjEgZmlsZSBj aGFuZ2VkLCAxMCBpbnNlcnRpb25zKCspCgo= --===============5351641486714044747==--