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.94.2) (envelope-from ) id 1tQ3ms-00HNjJ-TE for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Dec 2024 12:13:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tQ3ms-004oUG-Aa for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Dec 2024 12:13:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tPwfL-001UcL-NU for pgsql-bugs@lists.postgresql.org; Tue, 24 Dec 2024 04:37:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tPwfJ-000I7a-1U for pgsql-bugs@lists.postgresql.org; Tue, 24 Dec 2024 04:37:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Jml7YIh7c6VvD1KBr9J+B84dWxT+pXVxU1+cO4do2Jk=; b=lf2pYRZPGGBstmfMb6Ued1Gg3E D4RuF60TJL7CXSR/aHJ1x2uXWXehr8I+4BqxszZS+IR4mH1d8UyK/d1fYiQtG1uMhBQdDA4tymKA6 jLAnwPfPtGu2FKMr4C5rw2VEul0jo7KGv/0OeUI58nL8FhD89/rilD6+3XGODdrieBfVaaKWZyQrL 33Gm+74AkzyaESG6gkTHKruThsW5yp4KHl4yhkOTEkVj+rmnltpDxHf2Z51l3N0JFamlzGuCeYVwl 41QL3+6AJsRaD5PzUbC2MEsPcOX5NBBNl2mqE933T4QdwZ5rbtlIuhwIrStP8waUuPuUDEQ0ijcIt aMtILL2A==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tPwfI-003ZlG-6h for pgsql-bugs@lists.postgresql.org; Tue, 24 Dec 2024 04:37:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tPwfF-005Kgz-RQ for pgsql-bugs@lists.postgresql.org; Tue, 24 Dec 2024 04:37:02 +0000 Content-Type: multipart/mixed; boundary="===============9194204706525643738==" MIME-Version: 1.0 Subject: BUG #18753: Unable to Recover a Deleted Database Using PITR To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: relationaldbforbeginners@gmail.com Reply-To: relationaldbforbeginners@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 24 Dec 2024 04:36:40 +0000 Message-ID: <18753-02b5cc4f629e1e5d@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9194204706525643738== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODc1MwpMb2dnZWQgYnk6ICAgICAgICAgIFNjb3R0IFRheWxvcgpFbWFp bCBhZGRyZXNzOiAgICAgIHJlbGF0aW9uYWxkYmZvcmJlZ2lubmVyc0BnbWFpbC5jb20KUG9zdGdy ZVNRTCB2ZXJzaW9uOiAxNy4yCk9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMSBIb21lIFZl cnNpb24KRGVzY3JpcHRpb246ICAgICAgICAKCkNyZWF0ZWQgZGF0YWJhc2UgcmFuZG9tZGF0YSB3 aXRoIG9uZSB0YWJsZSBmb3IgdGVzdCBwdXJwb3NlcyBvZiBwb2ludCBpbgp0aW1lIHJlY292ZXJ5 Lg0KSG93ZXZlciwgdGhlIGRhdGFiYXNlIGRpZCBub3QgZnVsbHkgcmVzdG9yZS4NClRoaXMgY29u c2lzdGVudGx5IGRvZXMgbm90IHdvcmsuDQpJIGFtIHVzaW5nIHBvc3RncmVzIHZlcnNpb246IFBv c3RncmVTUUwgMTcuMiBvbiB4ODZfNjQtd2luZG93cw0KDQpTdGVwczoNCjEpIFVwZGF0ZWQgcG9z dGdyZXNxbC5jb25mOg0KICAgIGFyY2hpdmVfbW9kZSA9IG9uDQogICAgYXJjaGl2ZV9jb21tYW5k ID0gJ2NvcHkgIiVwIiAiQzpcXFBvc3RncmVzQXJjaGl2ZVxcV2FsLUFyY2hpdmVcXCVmIicNCiAg ICBsb2dfc3RhdGVtZW50ID0gbW9kDQogICAgc3VtbWFyaXplX3dhbCA9IG9uDQoNCjIpIFJlLXN0 YXJ0ZWQgcG9zdGdyZXMgc2VydmVyDQoNCjMpIENyZWF0ZWQgYSBkYXRhYmFzZSAicmFuZG9tZGF0 YSIgYW5kIHRhYmxlICJzb21lZGF0YSIsIGluc2VydGVkIGRhdGE6DQogICAgMjAyNC0xMi0wMiAx Mzo1NzoyNC4wNDkgRVNUIFszMTI2OF0gTE9HOiAgc3RhdGVtZW50OiBpbnNlcnQgaW50bwpzb21l ZGF0YSAoc2VyaWFsbnVtYmVyLCBmaXJzdG5hbWUsIGxhc3RuYW1lKQ0KDQo0KSBSYW4gcGdfYmFz ZWJhY2t1cA0KDQo1KSBEcm9wcGVkIGRhdGFiYXNlOg0KICAgIDIwMjQtMTItMDIgMTQ6MDE6Mjcu MjQzIEVTVCBbMTkxNDhdIExPRzogIHN0YXRlbWVudDogRFJPUCBEQVRBQkFTRQpyYW5kb21kYXRh Ow0KDQo2KSBTdG9wcGVkIHBvc3RncmVzIHNlcnZlcg0KDQo3KSBSZW1vdmVkIGNvbnRlbnRzIG9m IGRhdGEgZm9sZGVyOiBDOlxQcm9ncmFtIEZpbGVzXFBvc3RncmVTUUxcMTdcZGF0YQ0KDQo4KSBF eHRyYWN0ZWQgYmFzZS50YXIuZ3ogKGZyb20gcGdfYmFzZWJhY2t1cCkgaW50byBDOlxQcm9ncmFt CkZpbGVzXFBvc3RncmVTUUxcMTdcZGF0YQ0KDQo5KSBSZW1vdmVkIGNvbnRlbnRzIG9mIHBnX3dh bCBmb2xkZXI6IEM6XFByb2dyYW0KRmlsZXNcUG9zdGdyZVNRTFwxN1xkYXRhXHBnX3dhbA0KDQox MCkgQWRkZWQgdG8gcG9zdGdyZXNxbC5jb25mOg0KICAgIHJlc3RvcmVfY29tbWFuZCA9ICdjb3B5 ICJDOlxcUG9zdGdyZXNBcmNoaXZlXFxXYWwtQXJjaGl2ZVxcJWYiICIlcCInDQogICAgcmVjb3Zl cnlfdGFyZ2V0X3RpbWUgPSAnMjAyNC0xMi0wMiAxMzo1NzoyNCcgKHRpbWUgZnJvbSBsb2cgZmls ZSB3aGVuCmluc2VydCBvY2N1cnJlZCwgc2VlIHN0ZXAgMikNCiAgICByZWNvdmVyeV90YXJnZXRf YWN0aW9uID0gcHJvbW90ZQ0KDQoxMSkgQ3JlYXRlZCByZWNvdmVyeS5zaWduYWwgZmlsZSBpbiBw b3N0Z3JlcyBkYXRhIGZvbGRlcg0KDQoxMikgU3RhcnRlZCBwb3N0Z3JlcyBzZXJ2ZXINCg0KMTMp IEF0dGVtcHRlZCB0byBjb25uZWN0IHRvIGRhdGFiYXNlIHVzaW5nIHBzcWw6DQogICAgcG9zdGdy ZXM9IyBcYyByYW5kb21kYXRhOw0KICAgIGNvbm5lY3Rpb24gdG8gc2VydmVyIGF0ICJsb2NhbGhv c3QiICg6OjEpLCBwb3J0IDU0MzIgZmFpbGVkOiBGQVRBTDogCmNhbm5vdCBjb25uZWN0IHRvIGlu dmFsaWQgICAgZGF0YWJhc2UgInJhbmRvbWRhdGEiDQogICAgSElOVDogIFVzZSBEUk9QIERBVEFC QVNFIHRvIGRyb3AgaW52YWxpZCBkYXRhYmFzZXMuDQogICAgUHJldmlvdXMgY29ubmVjdGlvbiBr ZXB0DQoNCjE0KSBOb3RpY2VkIHJlY292ZXJ5LnNpZ25hbCBmaWxlIHdhcyByZW1vdmVkDQoNCkxv ZyBmaWxlIGNvbnRlbnRzOg0KMjAyNC0xMi0wMiAxMzo1NzoyMy44NTIgRVNUIFszMjM1Ml0gTE9H OiAgc3RhdGVtZW50OiBjcmVhdGUgZGF0YWJhc2UKcmFuZG9tZGF0YTsNCjIwMjQtMTItMDIgMTM6 NTc6MjQuMDQzIEVTVCBbMzEyNjhdIExPRzogIHN0YXRlbWVudDogY3JlYXRlIHRhYmxlIHNvbWVk YXRhCihpZCBzZXJpYWwgcHJpbWFyeSBrZXksIHNlcmlhbG51bWJlciBpbnRlZ2VyLCBmaXJzdG5h bWUgdGV4dCwgbGFzdG5hbWUKdGV4dCk7DQoyMDI0LTEyLTAyIDEzOjU3OjI0LjA0OSBFU1QgWzMx MjY4XSBMT0c6ICBzdGF0ZW1lbnQ6IGluc2VydCBpbnRvIHNvbWVkYXRhCihzZXJpYWxudW1iZXIs IGZpcnN0bmFtZSwgbGFzdG5hbWUpDQoNCi0gUmFuIHBnX2Jhc2ViYWNrdXANCg0KLSBEcm9wcGVk IGRhdGFiYXNlDQoyMDI0LTEyLTAyIDE0OjAxOjI3LjI0MyBFU1QgWzE5MTQ4XSBMT0c6ICBzdGF0 ZW1lbnQ6IERST1AgREFUQUJBU0UKcmFuZG9tZGF0YTsNCg0KLSBTdG9wcGVkIHNlcnZlcg0KLSBE ZWxldGVkIERhdGEgZm9sZGVyDQotIFJlc3RvcmVkIGZyb20gYmFja3VwIGZpbGUNCi0gQWRkZWQg cmVzdG9yZV9jb21tYW5kLCByZWNvdmVyeV90YXJnZXRfdGltZSwgcmVjb3ZlcnlfdGFyZ2V0X2Fj dGlvbiB0bwpwb3N0Z3Jlc3FsLmNvbmYNCi0gQ3JlYXRlZCByZW92ZXJ5LnNpZ25hbCBmaWxlDQot IFJlc3RhcnRlZCBzZXJ2ZXINCg0KMjAyNC0xMi0wMiAxNDowNDoyMS42MzAgRVNUIFsyMDE1Nl0g TE9HOiAgZGF0YWJhc2Ugc3lzdGVtIHdhcyBpbnRlcnJ1cHRlZDsKbGFzdCBrbm93biB1cCBhdCAy MDI0LTEyLTAyIDE0OjAwOjIyIEVTVA0KMjAyNC0xMi0wMiAxNDowNDoyMS42MzAgRVNUIFsyMDE1 Nl0gTE9HOiAgY3JlYXRpbmcgbWlzc2luZyBXQUwgZGlyZWN0b3J5CiJwZ193YWwvYXJjaGl2ZV9z dGF0dXMiDQoyMDI0LTEyLTAyIDE0OjA0OjIxLjYzMCBFU1QgWzIwMTU2XSBMT0c6ICBjcmVhdGlu ZyBtaXNzaW5nIFdBTCBkaXJlY3RvcnkKInBnX3dhbC9zdW1tYXJpZXMiDQoyMDI0LTEyLTAyIDE0 OjA0OjIyLjc5MiBFU1QgWzIwMTU2XSBMT0c6ICBzdGFydGluZyBiYWNrdXAgcmVjb3Zlcnkgd2l0 aCByZWRvCkxTTiAwLzMwMDAwMjgsIGNoZWNrcG9pbnQgTFNOIDAvMzAwMDA4MCwgb24gdGltZWxp bmUgSUQgMQ0KMjAyNC0xMi0wMiAxNDowNDoyMi44MDUgRVNUIFsyMDE1Nl0gTE9HOiAgcmVzdG9y ZWQgbG9nIGZpbGUKIjAwMDAwMDAxMDAwMDAwMDAwMDAwMDAwMyIgZnJvbSBhcmNoaXZlDQoyMDI0 LTEyLTAyIDE0OjA0OjIyLjgxOCBFU1QgWzIwMTU2XSBMT0c6ICBzdGFydGluZyBwb2ludC1pbi10 aW1lIHJlY292ZXJ5IHRvCjIwMjQtMTItMDIgMTM6NTc6MjQtMDUNCjIwMjQtMTItMDIgMTQ6MDQ6 MjIuODI1IEVTVCBbMjAxNTZdIExPRzogIHJlZG8gc3RhcnRzIGF0IDAvMzAwMDAyOA0KMjAyNC0x Mi0wMiAxNDowNDoyMi44MjYgRVNUIFsyMDE1Nl0gTE9HOiAgY29tcGxldGVkIGJhY2t1cCByZWNv dmVyeSB3aXRoCnJlZG8gTFNOIDAvMzAwMDAyOCBhbmQgZW5kIExTTiAwLzMwMDAxMjANCjIwMjQt MTItMDIgMTQ6MDQ6MjIuODI2IEVTVCBbMjAxNTZdIExPRzogIGNvbnNpc3RlbnQgcmVjb3Zlcnkg c3RhdGUgcmVhY2hlZAphdCAwLzMwMDAxMjANCjIwMjQtMTItMDIgMTQ6MDQ6MjIuODQzIEVTVCBb MjAxNTZdIExPRzogIHJlc3RvcmVkIGxvZyBmaWxlCiIwMDAwMDAwMTAwMDAwMDAwMDAwMDAwMDQi IGZyb20gYXJjaGl2ZQ0KMjAyNC0xMi0wMiAxNDowNDoyMi44NzEgRVNUIFsyMDE1Nl0gTE9HOiAg cmVjb3Zlcnkgc3RvcHBpbmcgYmVmb3JlIGNvbW1pdCBvZgp0cmFuc2FjdGlvbiA5NjksIHRpbWUg MjAyNC0xMi0wMiAxNDowMToyNy4yODExNjQtMDUNCjIwMjQtMTItMDIgMTQ6MDQ6MjIuODcxIEVT VCBbMjAxNTZdIExPRzogIHJlZG8gZG9uZSBhdCAwLzQwMDA2Rjggc3lzdGVtCnVzYWdlOiBDUFU6 IHVzZXI6IDAuMDAgcywgc3lzdGVtOiAwLjAwIHMsIGVsYXBzZWQ6IDAuMDQgcw0KMjAyNC0xMi0w MiAxNDowNDoyMi44NzkgRVNUIFsyMDE1Nl0gTE9HOiAgc2VsZWN0ZWQgbmV3IHRpbWVsaW5lIElE OiAyDQoyMDI0LTEyLTAyIDE0OjA0OjIyLjk0MCBFU1QgWzIwMTU2XSBMT0c6ICBhcmNoaXZlIHJl Y292ZXJ5IGNvbXBsZXRlDQoyMDI0LTEyLTAyIDE0OjA0OjIyLjk0MSBFU1QgWzMwNjU2XSBMT0c6 ICBjaGVja3BvaW50IHN0YXJ0aW5nOgplbmQtb2YtcmVjb3ZlcnkgaW1tZWRpYXRlIHdhaXQNCjIw MjQtMTItMDIgMTQ6MDQ6MjIuOTUyIEVTVCBbMzA2NTZdIExPRzogIGNoZWNrcG9pbnQgY29tcGxl dGU6IHdyb3RlIDQKYnVmZmVycyAoMC4wJSk7IDAgV0FMIGZpbGUocykgYWRkZWQsIDAgcmVtb3Zl ZCwgMSByZWN5Y2xlZDsgd3JpdGU9MC4wMDEgcywKc3luYz0wLjAwMyBzLCB0b3RhbD0wLjAxMiBz OyBzeW5jIGZpbGVzPTMsIGxvbmdlc3Q9MC4wMDEgcywgYXZlcmFnZT0wLjAwMSBzOwpkaXN0YW5j ZT0xNjM4NSBrQiwgZXN0aW1hdGU9MTYzODUga0I7IGxzbj0wLzQwMDA2RjgsIHJlZG8gbHNuPTAv NDAwMDZGOA0KDQoyMDI0LTEyLTAyIDE0OjA1OjM4LjE0MiBFU1QgWzE1ODc2XSBGQVRBTDogIGNh bm5vdCBjb25uZWN0IHRvIGludmFsaWQKZGF0YWJhc2UgInJhbmRvbWRhdGEiDQoyMDI0LTEyLTAy IDE0OjA1OjM4LjE0MiBFU1QgWzE1ODc2XSBISU5UOiAgVXNlIERST1AgREFUQUJBU0UgdG8gZHJv cCBpbnZhbGlkCmRhdGFiYXNlcy4KCg== --===============9194204706525643738==--