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 1tEEiY-006ANq-2t for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Nov 2024 21:28:02 +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 1tEEiW-001i3V-OI for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Nov 2024 21:28:00 +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 1tEEiV-001i3G-ST for pgsql-hackers@lists.postgresql.org; Thu, 21 Nov 2024 21:28:00 +0000 Received: from m16.mail.126.com ([220.197.31.7]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tEEiO-00375u-UF for pgsql-hackers@lists.postgresql.org; Thu, 21 Nov 2024 21:27:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=6atNS/o4N2810eS9MGvFg9cNiFfmJJH+0PHKMbA2db0=; b=A oFE8R4cf+GU7CaHuOB1w2wbs8FaUdE/n0RHGKFZCpa/hn116qVK/yM208tZq1ad+ dImCp2npath86S2dFUv+cGDhPt6p5x6xrkKdcVINzAVLDS2esJ9K941b6K0JbQUV 2ZC8a3V0Co4RiMWwfqiSK2dRYSsIL4+rSuZY2T9phE= Received: from yyuansong$126.com ( [240e:398:384:21a0:8da3:a6a4:59ed:8a07] ) by ajax-webmail-wmsvr-41-117 (Coremail) ; Fri, 22 Nov 2024 05:26:53 +0800 (CST) X-Originating-IP: [240e:398:384:21a0:8da3:a6a4:59ed:8a07] Date: Fri, 22 Nov 2024 05:26:53 +0800 (CST) From: yuansong To: "Peter Geoghegan" , pgsql-hackers@lists.postgresql.org Subject: Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20240801(9da12a7b) Copyright (c) 2002-2024 www.mailtech.cn 126com In-Reply-To: References: X-NTES-SC: AL_Qu2YAP6Zu0wq5SWQYekfmkoRhek4UMCxvv4i2Y5VNptwjA7j6AYHem1RLGPV7tOpKC6okgqFTzte1ORFcbVRf4Qz9xb885mfGnD5zF1qZZv4cg== Content-Type: multipart/alternative; boundary="----=_Part_214_1307217665.1732224413589" MIME-Version: 1.0 Message-ID: <35b0b8dc.21.193509eef96.Coremail.yyuansong@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: dSkvCgD3P6+dpT9nAjEsAA--.1471W X-CM-SenderInfo: p11xt0pvrqwqqrswhudrp/1tbiWQ+e2Gc-mkVmLQACse X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_214_1307217665.1732224413589 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 VGhlcmUgbWF5IGJlIHNvbWV0aGluZyB3cm9uZyB3aXRoIG15IHByZXZpb3VzIGRlc2NyaXB0aW9u LCAiU2hvdWxkIG5odGlkcyBiZSBsZXNzIHRoYW4gb3IgZXF1YWwgdG8gSW5kZXhUdXBsZVNpemUo b3Bvc3RpbmcpPwoKV2h5IGlzIG5odGlkcyBsYXJnZXIgdGhhbiBJbmRleFR1cGxlU2l6ZShvcG9z dGluZykgIiBIZXJlIG5odGlkcyBzaG91bGQgYmUgbm1vdmVieXRlcy4KCkl0IGlzIG5vcm1hbCB3 aGV0aGVyIG5odGlkcyBpcyBsYXJnZXIgdGhhbiBJbmRleFR1cGxlU2l6ZShvcG9zdGluZykgb3Ig c21hbGxlciB0aGFuIEluZGV4VHVwbGVTaXplKG9wb3N0aW5nKS4KClNob3VsZCBubW92ZWJ5dGVz IGJlIHNtYWxsZXIgdGhhbiBJbmRleFR1cGxlU2l6ZShvcG9zdGluZyk/CgoKCgpJIGNoZWNrZWQg dGhlIGxhdGVzdCBjb2RlIG9mIHRoZSBtYXN0ZXIgYnJhbmNoIGJ0cmVl77yIYmFja2VuZFxhY2Nl c3NcbmJ0cmVl77yJIGFuZCBkaWQgbm90IGZpbmQgYW55IHJlbGF0ZWQgZml4ZXMuIApUaGlzIGlz IGFsc28gYSBsb3ctcHJvYmFiaWxpdHkgZXZlbnQgYW5kIGlzIGRpZmZpY3VsdCB0byByZXByb2R1 Y2UuCgpBdCAyMDI0LTExLTIxIDIzOjU4OjAzLCAiUGV0ZXIgR2VvZ2hlZ2FuIiA8cGdAYm93dC5p ZT4gd3JvdGU6Cj5PbiBUaHUsIE5vdiAyMSwgMjAyNCBhdCAxMDowM+KAr0FNIHl1YW5zb25nIDx5 eXVhbnNvbmdAMTI2LmNvbT4gd3JvdGU6Cj4+IFNob3VsZCBuaHRpZHMgYmUgbGVzcyB0aGFuIG9y IGVxdWFsIHRvIEluZGV4VHVwbGVTaXplKG9wb3N0aW5nKT8KPj4gIFdoeSBpcyBuaHRpZHMgbGFy Z2VyIHRoYW4gSW5kZXhUdXBsZVNpemUob3Bvc3RpbmcpID8gSSB0aGluayB0aGVyZSBzaG91bGQg YmUgYW4gZXJyb3IgaW4gdGhlIG1hc3RlciBob3N0IHdyaXRpbmcgdGhlIHdhbCBsb2cuCj4+IERv ZXMgYW55b25lIGtub3cgd2hlbiB0aGlzIHdpbGwgaGFwcGVuPwo+Cj5JdCdsbCBoYXBwZW4gd2hl bmV2ZXIgdGhlcmUgaXMgYSBjZXJ0YWluIGtpbmQgb2YgZGF0YSBjb3JydXB0aW9uLgo+Cj5UaGVy ZSB3ZXJlIGNvbXBsYWludHMgYWJvdXQgaXNzdWVzIGxpa2UgdGhpcyBpbiB0aGUgcGFzdC4gQnV0 IHRob3NlCj5jb21wbGFpbnRzIHNlZW0gdG8gaGF2ZSBnb25lIGF3YXkgd2hlbiBtb3JlIGhhcmRl bmluZyB3YXMgYWRkZWQgdG8gdGhlCj5jb2RlIHRoYXQgcnVucyBkdXJpbmcgb3JpZ2luYWwgZXhl Y3V0aW9uIChub3QgdGhlIFJFRE8gcm91dGluZSBjb2RlLAo+d2hpY2ggY2FuIG9ubHkgZG8gd2hh dCBpdCBpcyB0b2xkIHRvIGRvIGJ5IHRoZSBXQUwgcmVjb3JkKS4KPgo+WW91J3JlIHVzaW5nIFBv c3RncmVTUUwgMTMuMiwgd2hpY2ggaXMgYSB2ZXJ5IG9sZCBwb2ludCByZWxlYXNlIHRoYXQKPmxh Y2tzIHRoaXMgaGFyZGVuaW5nIC0tIHRoZSBjdXJyZW50IDEzIHBvaW50IHJlbGVhc2UgaXMgMTMu MTgsIHNvCj55b3UncmUgbWlzc2luZyBhIGxvdC4gSGFkIHlvdSBiZWVuIG9uIGEgbGF0ZXIgcG9p bnQgcmVsZWFzZSB5b3UnZCB2ZXJ5Cj5wcm9iYWJseSBoYXZlIHN0aWxsIGhhZCB0aGUgaXNzdWUg d2l0aCBjb3JydXB0aW9uICh3aGljaCBjb3VsZCBiZSBmcm9tCj5iYWQgaGFyZHdhcmUpLCBidXQg eW91IGxpa2VseSB3b3VsZCBoYXZlIGF2b2lkZWQgdGhlIHByb2JsZW0gd2l0aCB0aGUKPlJFRE8g cm91dGluZSBjcmFzaGluZyBsaWtlIHRoaXMuCj4KPi0tIAo+UGV0ZXIgR2VvZ2hlZ2FuCg== ------=_Part_214_1307217665.1732224413589 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdiBp ZD0ic3BuRWRpdG9yQ29udGVudCI+PHAgc3R5bGU9Im1hcmdpbjogMDsiPlRoZXJlIG1heSBiZSBz b21ldGhpbmcgd3Jvbmcgd2l0aCBteSBwcmV2aW91cyBkZXNjcmlwdGlvbiwgIlNob3VsZCBuaHRp ZHMgYmUgbGVzcyB0aGFuIG9yIGVxdWFsIHRvIEluZGV4VHVwbGVTaXplKG9wb3N0aW5nKT88L3A+ PHAgc3R5bGU9Im1hcmdpbjogMDsiPldoeSBpcyBuaHRpZHMgbGFyZ2VyIHRoYW4gSW5kZXhUdXBs ZVNpemUob3Bvc3RpbmcpICIgSGVyZSBuaHRpZHMgc2hvdWxkIGJlIG5tb3ZlYnl0ZXMuPC9wPjxw IHN0eWxlPSJtYXJnaW46IDA7Ij5JdCBpcyBub3JtYWwgd2hldGhlciBuaHRpZHMgaXMgbGFyZ2Vy IHRoYW4gSW5kZXhUdXBsZVNpemUob3Bvc3RpbmcpIG9yIHNtYWxsZXIgdGhhbiBJbmRleFR1cGxl U2l6ZShvcG9zdGluZykuPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5TaG91bGQgbm1vdmVieXRl cyBiZSBzbWFsbGVyIHRoYW4gSW5kZXhUdXBsZVNpemUob3Bvc3RpbmcpPzwvcD48cCBzdHlsZT0i bWFyZ2luOiAwOyI+PGJyPjwvcD48L2Rpdj48ZGl2IHN0eWxlPSJwb3NpdGlvbjpyZWxhdGl2ZTt6 b29tOjEiPjwvZGl2PjxkaXYgaWQ9ImRpdk5ldGVhc2VNYWlsQ2FyZCI+PC9kaXY+PGRpdiBzdHls ZT0ibWFyZ2luOiAwOyI+SSBjaGVja2VkIHRoZSBsYXRlc3QgY29kZSBvZiB0aGUgbWFzdGVyIGJy YW5jaCBidHJlZe+8iGJhY2tlbmRcYWNjZXNzXG5idHJlZe+8iSBhbmQgZGlkIG5vdCBmaW5kIGFu eSByZWxhdGVkIGZpeGVzLiZuYnNwOzwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPlRoaXMg aXMgYWxzbyBhIGxvdy1wcm9iYWJpbGl0eSBldmVudCBhbmQgaXMgZGlmZmljdWx0IHRvIHJlcHJv ZHVjZS48L2Rpdj48cHJlPjxicj5BdCAyMDI0LTExLTIxIDIzOjU4OjAzLCAiUGV0ZXIgR2VvZ2hl Z2FuIiAmbHQ7cGdAYm93dC5pZSZndDsgd3JvdGU6CiZndDtPbiBUaHUsIE5vdiAyMSwgMjAyNCBh dCAxMDowM+KAr0FNIHl1YW5zb25nICZsdDt5eXVhbnNvbmdAMTI2LmNvbSZndDsgd3JvdGU6CiZn dDsmZ3Q7IFNob3VsZCBuaHRpZHMgYmUgbGVzcyB0aGFuIG9yIGVxdWFsIHRvIEluZGV4VHVwbGVT aXplKG9wb3N0aW5nKT8KJmd0OyZndDsgIFdoeSBpcyBuaHRpZHMgbGFyZ2VyIHRoYW4gSW5kZXhU dXBsZVNpemUob3Bvc3RpbmcpID8gSSB0aGluayB0aGVyZSBzaG91bGQgYmUgYW4gZXJyb3IgaW4g dGhlIG1hc3RlciBob3N0IHdyaXRpbmcgdGhlIHdhbCBsb2cuCiZndDsmZ3Q7IERvZXMgYW55b25l IGtub3cgd2hlbiB0aGlzIHdpbGwgaGFwcGVuPwomZ3Q7CiZndDtJdCdsbCBoYXBwZW4gd2hlbmV2 ZXIgdGhlcmUgaXMgYSBjZXJ0YWluIGtpbmQgb2YgZGF0YSBjb3JydXB0aW9uLgomZ3Q7CiZndDtU aGVyZSB3ZXJlIGNvbXBsYWludHMgYWJvdXQgaXNzdWVzIGxpa2UgdGhpcyBpbiB0aGUgcGFzdC4g QnV0IHRob3NlCiZndDtjb21wbGFpbnRzIHNlZW0gdG8gaGF2ZSBnb25lIGF3YXkgd2hlbiBtb3Jl IGhhcmRlbmluZyB3YXMgYWRkZWQgdG8gdGhlCiZndDtjb2RlIHRoYXQgcnVucyBkdXJpbmcgb3Jp Z2luYWwgZXhlY3V0aW9uIChub3QgdGhlIFJFRE8gcm91dGluZSBjb2RlLAomZ3Q7d2hpY2ggY2Fu IG9ubHkgZG8gd2hhdCBpdCBpcyB0b2xkIHRvIGRvIGJ5IHRoZSBXQUwgcmVjb3JkKS4KJmd0Owom Z3Q7WW91J3JlIHVzaW5nIFBvc3RncmVTUUwgMTMuMiwgd2hpY2ggaXMgYSB2ZXJ5IG9sZCBwb2lu dCByZWxlYXNlIHRoYXQKJmd0O2xhY2tzIHRoaXMgaGFyZGVuaW5nIC0tIHRoZSBjdXJyZW50IDEz IHBvaW50IHJlbGVhc2UgaXMgMTMuMTgsIHNvCiZndDt5b3UncmUgbWlzc2luZyBhIGxvdC4gSGFk IHlvdSBiZWVuIG9uIGEgbGF0ZXIgcG9pbnQgcmVsZWFzZSB5b3UnZCB2ZXJ5CiZndDtwcm9iYWJs eSBoYXZlIHN0aWxsIGhhZCB0aGUgaXNzdWUgd2l0aCBjb3JydXB0aW9uICh3aGljaCBjb3VsZCBi ZSBmcm9tCiZndDtiYWQgaGFyZHdhcmUpLCBidXQgeW91IGxpa2VseSB3b3VsZCBoYXZlIGF2b2lk ZWQgdGhlIHByb2JsZW0gd2l0aCB0aGUKJmd0O1JFRE8gcm91dGluZSBjcmFzaGluZyBsaWtlIHRo aXMuCiZndDsKJmd0Oy0tIAomZ3Q7UGV0ZXIgR2VvZ2hlZ2FuCjwvcHJlPjwvZGl2Pg== ------=_Part_214_1307217665.1732224413589--