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 1oIymM-0002YG-7O for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 20:46:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIylN-00020u-3J for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 20:45:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIylM-00020I-C1 for pgsql-hackers@lists.postgresql.org; Tue, 02 Aug 2022 20:45:12 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIylF-00018O-I7 for pgsql-hackers@postgresql.org; Tue, 02 Aug 2022 20:45:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:References:Cc:To: From:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=CysLodVuEwoBMIhY5giIyFL5q68wq5QFSzHef4jN5as=; b=fMjRGl9m0YCnsT2d8PkQdVctu2 tMA6A8jrjMyEsX5uxSIwjU73uFyTxs18Q+WL/2q+i9tXIvQPd3xWhcel0+LmO5ubZ8cnYSFWvLoiX aVVtJeiWgrB8jeQsYFZ4zo/OGpdpucr6p3qIq4jQ5l0UTdN5YNHDQGCA3vVVR+/BozcKd/ueKFwRK D5g2QWaOJdqfBFGjR4t0ULkx5lPY7zf0FBXptC6YOKFlUVWFlDna1+pp4JN/oQfBG6RkAK7eXxXOw DECccCQVxgGe6chE6faaQRYoUPOQT8O+R8n4LHzX/jJ4Hi84eDA+b40lPlbZlu0S2Y5goOukiRGIn Pmb2RcFg==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oIyl7-0003Us-3p; Tue, 02 Aug 2022 20:44:59 +0000 Message-ID: <286460a2-75ce-ab54-9da1-c817e7ae6f51@postgresql.org> Date: Tue, 2 Aug 2022 16:44:52 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.11.0 Subject: Re: pg15b2: large objects lost on upgrade Content-Language: en-US From: "Jonathan S. Katz" To: Tom Lane Cc: Robert Haas , Noah Misch , Andrew Dunstan , Bruce Momjian , Michael Paquier , Justin Pryzby , "pgsql-hackers@postgresql.org" , Shruthi Gowda References: <3901843.1659116952@sss.pgh.pa.us> <4152163.1659124804@sss.pgh.pa.us> <125444.1659136594@sss.pgh.pa.us> <20220730054401.GB3644221@rfd.leadboat.com> <351616.1659192034@sss.pgh.pa.us> <635c8809-3525-7dae-a1a1-0d9069cd86bc@postgresql.org> <2657259.1659460333@sss.pgh.pa.us> <2686054.1659469199@sss.pgh.pa.us> <98286e9b-8fe6-554e-c23f-d67a3df2c30d@postgresql.org> <2687956.1659469881@sss.pgh.pa.us> <06f74ad5-9e28-85ae-35ae-cbb6a2d756b8@postgresql.org> In-Reply-To: <06f74ad5-9e28-85ae-35ae-cbb6a2d756b8@postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------0oTRHOjoROKnuIrWQZKPZXke" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------0oTRHOjoROKnuIrWQZKPZXke Content-Type: multipart/mixed; boundary="------------IRQx1RnfgKqeYWF3zr7FLalO"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane Cc: Robert Haas , Noah Misch , Andrew Dunstan , Bruce Momjian , Michael Paquier , Justin Pryzby , "pgsql-hackers@postgresql.org" , Shruthi Gowda Message-ID: <286460a2-75ce-ab54-9da1-c817e7ae6f51@postgresql.org> Subject: Re: pg15b2: large objects lost on upgrade References: <3901843.1659116952@sss.pgh.pa.us> <4152163.1659124804@sss.pgh.pa.us> <125444.1659136594@sss.pgh.pa.us> <20220730054401.GB3644221@rfd.leadboat.com> <351616.1659192034@sss.pgh.pa.us> <635c8809-3525-7dae-a1a1-0d9069cd86bc@postgresql.org> <2657259.1659460333@sss.pgh.pa.us> <2686054.1659469199@sss.pgh.pa.us> <98286e9b-8fe6-554e-c23f-d67a3df2c30d@postgresql.org> <2687956.1659469881@sss.pgh.pa.us> <06f74ad5-9e28-85ae-35ae-cbb6a2d756b8@postgresql.org> In-Reply-To: <06f74ad5-9e28-85ae-35ae-cbb6a2d756b8@postgresql.org> --------------IRQx1RnfgKqeYWF3zr7FLalO Content-Type: multipart/mixed; boundary="------------VlrCecCRW86LwWFpUqOaWpj5" --------------VlrCecCRW86LwWFpUqOaWpj5 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8yLzIyIDQ6MjAgUE0sIEpvbmF0aGFuIFMuIEthdHogd3JvdGU6DQo+IE9uIDgvMi8y MiAzOjUxIFBNLCBUb20gTGFuZSB3cm90ZToNCj4+ICJKb25hdGhhbiBTLiBLYXR6IiA8amth dHpAcG9zdGdyZXNxbC5vcmc+IHdyaXRlczoNCj4+PiBPbiA4LzIvMjIgMzozOSBQTSwgVG9t IExhbmUgd3JvdGU6DQo+Pj4+PiBJIGFtIG5vdCBpbiBmYXZvciBvZiBkaXNhYmxpbmcgYXV0 b3ZhY3V1bSBpbiB0aGUgdGVzdDogb3JkaW5hcnkNCj4+Pj4+IHVzZXJzIGFyZSBub3QgZ29p bmcgdG8gZG8gdGhhdCB3aGlsZSBwZ191cGdyYWRlJ2luZywgc28gaXQnZCBtYWtlDQo+Pj4+ PiB0aGUgdGVzdCBsZXNzIHJlcHJlc2VudGF0aXZlIG9mIHJlYWwtd29ybGQgdXNhZ2UsIHdo aWNoIHNlZW1zIGxpa2UNCj4+Pj4+IGEgYmFkIGlkZWEuwqAgV2UgY291bGQgZWl0aGVyIGRy b3AgdGhpcyBwYXJ0aWN1bGFyIGNoZWNrIGFnYWluLCBvcg0KPj4+Pj4gd2Vha2VuIGl0IHRv IGFsbG93IG5ldyByZWxmcm96ZW54aWQgPj0gb2xkIHJlbGZyb3plbnhpZCwgbGlrZXdpc2UN Cj4+Pj4+IHJlbG1pbnhpZC4NCj4+DQo+Pj4gVGhlIHRlc3QgZG9lcyBsb29rIGhlbHBmdWwg YW5kIGl0IHdvdWxkIGNhdGNoIHJlZ3Jlc3Npb25zLiBMb29zZWx5DQo+Pj4gcXVvdGluZyBS b2JlcnQgb24gYSBkaWZmZXJlbnQgcG9pbnQgdXB0aHJlYWQsIHdlIGRvbid0IHdhbnQgdG8g dHVybiBvZmYNCj4+PiB0aGUgYWxhcm0ganVzdCBiZWNhdXNlIGl0J3Mgc3B1cmlvdXNseSBn b2luZyBvZmYuDQo+Pj4gSSB0aGluayB0aGUgd2Vha2VuZWQgY2hlY2sgaXMgT0sgKGFuZCBw b3NzaWJseSBtaW1pY3MgdGhlIHJlYWwtd29ybGQNCj4+PiB3aGVyZSBhdXRvdmFjdXVtIHJ1 bnMpLCB1bmxlc3MgeW91IHNlZSBhIG1ham9yIGRyYXdiYWNrIHRvIGl0Pw0KPj4NCj4+IEkg YWxzbyB0aGluayB0aGF0ICI+PSIgaXMgYSBzdWZmaWNpZW50IHJlcXVpcmVtZW50LsKgIEl0 J2QgYmUgYQ0KPj4gYml0IHBhaW5mdWwgdG8gdGVzdCBpZiB3ZSBoYWQgdG8gY29wZSB3aXRo IHBvdGVudGlhbCBYSUQgd3JhcGFyb3VuZCwNCj4+IGJ1dCB3ZSBrbm93IHRoYXQgdGhlc2Ug aW5zdGFsbGF0aW9ucyBoYXZlbid0IGJlZW4gYXJvdW5kIG5lYXJseQ0KPj4gbG9uZyBlbm91 Z2ggZm9yIHRoYXQsIHNvIGEgcGxhaW4gIj49IiB0ZXN0IG91Z2h0IHRvIGJlIGdvb2QgZW5v dWdoLg0KPj4gKFJlcGxhY2luZyB0aGUgc2ltcGxlICJlcSIgY29kZSB3aXRoIHNvbWV0aGlu ZyB0aGF0IGNhbiBoYW5kbGUgdGhhdA0KPj4gZG9lc24ndCBsb29rIGxpa2UgbXVjaCBmdW4s IHRob3VnaC4pDQo+IA0KPiAuLi5pZiB0aGVzZSBzeXN0ZW1zIGFyZSBoaXR0aW5nIFhJRCB3 cmFwYXJvdW5kLCB3ZSBoYXZlIGFub3RoZXIgaXNzdWUgdG8gDQo+IHdvcnJ5IGFib3V0Lg0K PiANCj4gSSBzdGFydGVkIG1vZGlmeWluZyB0aGUgdGVzdCB0byBzdXBwb3J0IHRoaXMgYmVo YXZpb3IsIGJ1dCB0aG91Z2h0IHRoYXQgDQo+IGJlY2F1c2UgMS4gd2Ugd2FudCB0byBlbnN1 cmUgdGhlIE9JRCBpcyBzdGlsbCBlcXVhbCBhbmQgMi4gaW4gdGhlIA0KPiBleGFtcGxlcyB5 b3Ugc2hvd2VkLCBib3RoIHJlbGZyb3plbnhpZCBvciByZWxtaW54aWQgY291bGQgaW5jcmVt ZW50LCB3ZSANCj4gbWF5IHdhbnQgdG8gaGF2ZSB0aGUgaW5kaXZpZHVhbCBjaGVja3Mgb24g ZWFjaCBjb2x1bW4uDQo+IA0KPiBJIG1heSBiZSBhYmxlIHRvIGNvbmp1cmUgc29tZXRoaW5n IHVwIHRoYXQgZG9lcyB0aGUgYWJvdmUsIGJ1dCBpdCdzIGJlZW4gDQo+IGEgbWludXRlIHNp bmNlIEkgd3JvdGUgYW55dGhpbmcgaW4gUGVybC4NCg0KUGxlYXNlIHNlZSBhdHRhY2hlZCBw YXRjaCB0aGF0IGRvZXMgdGhlIGFib3ZlLiBUZXN0cyBwYXNzIG9uIG15IGxvY2FsIA0KZW52 aXJvbm1lbnQgKHRob3VnaCBJIGRpZCBub3QgdHJpZ2dlciBhdXRvdmFjdXVtKS4NCg0KSm9u YXRoYW4NCg== --------------VlrCecCRW86LwWFpUqOaWpj5 Content-Type: text/plain; charset=UTF-8; name="pg_upgrade-test-gte-xid.patch" Content-Disposition: attachment; filename="pg_upgrade-test-gte-xid.patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iaW4vcGdfdXBncmFkZS90LzAwMl9wZ191cGdyYWRlLnBsIGIv c3JjL2Jpbi9wZ191cGdyYWRlL3QvMDAyX3BnX3VwZ3JhZGUucGwKaW5kZXggNGNiYzc1NjQ0 Yy4uZTJiNzM5YmVmZiAxMDA2NDQKLS0tIGEvc3JjL2Jpbi9wZ191cGdyYWRlL3QvMDAyX3Bn X3VwZ3JhZGUucGwKKysrIGIvc3JjL2Jpbi9wZ191cGdyYWRlL3QvMDAyX3BnX3VwZ3JhZGUu cGwKQEAgLTIyNiw2ICsyMjYsOCBAQCBPUkRFUiBCWSBjLm9pZDo6cmVnY2xhc3M6OnRleHQK IEVPTQogJGhvcml6b25fcXVlcnkgPX4gcy9ccysvIC9nOyAjIHJ1biBpdCB0b2dldGhlciBv biBvbmUgbGluZQogbXkgJGhvcml6b24xID0gJG9sZG5vZGUtPnNhZmVfcHNxbCgncmVncmVz c2lvbicsICRob3Jpem9uX3F1ZXJ5KTsKK2Nob21wKCRob3Jpem9uMSk7CitteSBAaG9yaXpv bjFfdmFsdWVzID0gc3BsaXQoL1x8LywgJGhvcml6b24xKTsKIAogIyBJbiBhIFZQQVRIIGJ1 aWxkLCB3ZSdsbCBiZSBzdGFydGVkIGluIHRoZSBzb3VyY2UgZGlyZWN0b3J5LCBidXQgd2Ug d2FudAogIyB0byBydW4gcGdfdXBncmFkZSBpbiB0aGUgYnVpbGQgZGlyZWN0b3J5IHNvIHRo YXQgYW55IGZpbGVzIGdlbmVyYXRlZCBmaW5pc2gKQEAgLTMxMyw2ICszMTUsOCBAQCAkbmV3 bm9kZS0+Y29tbWFuZF9vaygKIAogIyBBbmQgcmVjb3JkIHRoZSBob3Jpem9ucyBmcm9tIHRo ZSB1cGdyYWRlZCBjbHVzdGVyIGFzIHdlbGwuCiBteSAkaG9yaXpvbjIgPSAkbmV3bm9kZS0+ c2FmZV9wc3FsKCdyZWdyZXNzaW9uJywgJGhvcml6b25fcXVlcnkpOworY2hvbXAoJGhvcml6 b24yKTsKK215IEBob3Jpem9uMl92YWx1ZXMgPSBzcGxpdCgvXHwvLCAkaG9yaXpvbjIpOwog CiAjIENvbXBhcmUgdGhlIHR3byBkdW1wcywgdGhlcmUgc2hvdWxkIGJlIG5vIGRpZmZlcmVu Y2VzLgogbXkgJGNvbXBhcmVfcmVzID0gY29tcGFyZSgiJHRlbXBkaXIvZHVtcDEuc3FsIiwg IiR0ZW1wZGlyL2R1bXAyLnNxbCIpOwpAQCAtMzMxLDggKzMzNSwxMyBAQCBpZiAoJGNvbXBh cmVfcmVzICE9IDApCiAJcHJpbnQgIj09PSBFT0YgPT09XG4iOwogfQogCi0jIENvbXBhcmUg dGhlIGhvcml6b25zLCB0aGVyZSBzaG91bGQgYmUgbm8gZGlmZmVyZW5jZXMuCi1teSAkaG9y aXpvbnNfb2sgPSAkaG9yaXpvbjEgZXEgJGhvcml6b24yOworIyBDb21wYXJlIHRoZSBob3Jp em9ucy4gVGhlcmUgc2hvdWxkIGJlIG5vIGNoYW5nZSBpbiB0aGUgT0lELCBzbyB3ZSB3aWxs IHRlc3QKKyMgZm9yIGVxdWFsaXR5LiBIb3dldmVyLCBiZWNhdXNlIGF1dG92YWN1dW0gbWF5 IGhhdmUgcnVuIGJldHdlZW4gdGhlIHR3bworIyBob3JpemlvbnMsIHdlIHdpbGwgY2hlY2sg aWYgdGhlIHVwZGF0ZWQgaG9yaXpvbiBYSURzIGFyZSBncmVhdGVyIHRoYW4gb3IKKyMgZXF1 YWwgdG8gdGhlIG9yaWdpbmFscy4KK215ICRob3Jpem9uc19vayA9ICRob3Jpem9uMl92YWx1 ZXNbMF0gZXEgJGhvcml6b24xX3ZhbHVlc1swXSAmJgorCWludCgkaG9yaXpvbjJfdmFsdWVz WzFdKSA+PSBpbnQoJGhvcml6b24xX3ZhbHVlc1sxXSkgJiYKKwlpbnQoJGhvcml6b24yX3Zh bHVlc1syXSkgPj0gaW50KCRob3Jpem9uMV92YWx1ZXNbMl0pOwogb2soJGhvcml6b25zX29r LCAnb2xkIGFuZCBuZXcgaG9yaXpvbnMgbWF0Y2ggYWZ0ZXIgcGdfdXBncmFkZScpOwogCiAj IFByb3ZpZGUgbW9yZSBjb250ZXh0IGlmIHRoZSBob3Jpem9ucyBkbyBub3QgbWF0Y2guCg== --------------VlrCecCRW86LwWFpUqOaWpj5-- --------------IRQx1RnfgKqeYWF3zr7FLalO-- --------------0oTRHOjoROKnuIrWQZKPZXke Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmLpjMQFAwAAAAAACgkQ8QSccp8cZSef EhAAmnEvs6IQGgGRq+JOJ89F1icF5+MgR/vFSAKxBVUfWViddxj1keSaoyo9o0HcrG/xr+YgArgH zpqr4FqUHhY79rFmjabJvFaAJ3xMi3vtJiZpJQJh5LRu9InUCiPNqMx5G1V+PtxvxQYjQrNfqNuG t6LdJvyuZ76qc0BVGqE3uwQhbMqZ5vV+11011C1S+HJ31msXtTFdsCwduMcmNhIQMMfbVRMcxHNq 9kX2k847kteYrEiajdmywb4UNQM3Gegg0PVa4QtNEmPYZfsrFiIrSQsO4PYMMSctHwGfWIXveIs+ cRCirK3Gh7ZIpieusrjikHt4IAnTCAaHl3c/tQrKACJI6GscAVFFuxpWyaErtz4mQV0PECZiQrfv T1do0+fcGCEvR0CEPOm3re9FOvVBtgk3bsMVfYpyPEzrEopxy6fGcKHg8QFe2AIAt+8Ekto/gFiF WhWDD1kLsLUaAEq1bHLm9G+bCIfzrrO1CoI4oMEq5PxYMV+cpy2qVXOH18YXE3Fl6+ld+YEGLnRz VXrMlcT43l9+MOWHipyca00s+VB6ZB/T9/Y33IhNBvzuEHl4Ty2jA5ns0nfUvm2SS8SguExaEj2Y +KDDoYeB9nq1ch32GlgbuzwdHa029hWfdB6BcxvJQ/g1jfgLFAoyMGEQ24PLxlUtb0E9qb0dZP81 n60= =3EFS -----END PGP SIGNATURE----- --------------0oTRHOjoROKnuIrWQZKPZXke--