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 1oIxoy-000847-It for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 19:44:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIxox-0001lL-Gl for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 19:44:51 +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 1oIxox-0001kF-74 for pgsql-hackers@lists.postgresql.org; Tue, 02 Aug 2022 19:44:51 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIxov-0003sw-8c for pgsql-hackers@postgresql.org; Tue, 02 Aug 2022 19:44:50 +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:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=8zNzmCeh9R8EfloqCDcSdEZ2ajn14mlsqUk1+95QIoU=; b=O+5aQ3p6ILvaE1e6z6IPAiFOad XApZYrSA01d5tx1BVNgktNgo251VB+LKH33RUlIBodAgHAYcOPjnLytShvwZ7YRJqoii8PB5IvRnZ +aTgakB4z9VaU6u1AE+yFaJZ5mgWIYoNiOR0E7+VT2PNs0BXyEV1c08zq2U1q2Y5F3rlgaz8Mw7yH tXtKJJdaNd5QD2yB9FWvh7fKSPU/msb0dXxBcv2/zDnbppIGoIBPBUjeD90qGMJ3KzPABDn0al560 AyKGhtyGC4aVs6fKSAwVvH1yOnCZnAfMMoEeanUgf0uzSky+33q++JkMiUXcPU8xe5IXu3rSYM5ns h+UBKknQ==; 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 1oIxoq-0002mm-7A; Tue, 02 Aug 2022 19:44:46 +0000 Message-ID: <98286e9b-8fe6-554e-c23f-d67a3df2c30d@postgresql.org> Date: Tue, 2 Aug 2022 15:44:40 -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 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> From: "Jonathan S. Katz" In-Reply-To: <2686054.1659469199@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------6nIvKogOfIKBfuyr1eXE71Y4" 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) --------------6nIvKogOfIKBfuyr1eXE71Y4 Content-Type: multipart/mixed; boundary="------------S07L8D1xY1UjpGEtbd020b0q"; 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: <98286e9b-8fe6-554e-c23f-d67a3df2c30d@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> In-Reply-To: <2686054.1659469199@sss.pgh.pa.us> --------------S07L8D1xY1UjpGEtbd020b0q Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8yLzIyIDM6MzkgUE0sIFRvbSBMYW5lIHdyb3RlOg0KPiAiSm9uYXRoYW4gUy4gS2F0 eiIgPGprYXR6QHBvc3RncmVzcWwub3JnPiB3cml0ZXM6DQo+PiBPbiA4LzIvMjIgMzoyMyBQ TSwgUm9iZXJ0IEhhYXMgd3JvdGU6DQo+Pj4gSSdtIG5vdCBxdWl0ZSBzdXJlIGhvdyB0byBy dWxlIHRoYXQgdGhlb3J5IGluIG9yIG91dCwgdGhvdWdoLg0KPiANCj4+IFdpdGhvdXQgb3Zl cmNvbXBsaWNhdGluZyB0aGlzLCBhcmUgd2UgYWJsZSB0byBjaGVjayB0byBzZWUgaWYgYXV0 b3ZhY3V1bQ0KPj4gcmFuIGR1cmluZyB0aGUgY291cnNlIG9mIHRoZSB0ZXN0Pw0KPiANCj4g TG9va3MgbGlrZSB3ZSdyZSBhbGwgdGhpbmtpbmcgYWxvbmcgdGhlIHNhbWUgbGluZXMuDQo+ IA0KPiBXaGlsZSBub3Qgc21va2luZyBndW5zLCB0aGVzZSBkZWZpbml0ZWx5IHByb3ZlIHRo YXQgYXV0b3ZhYyB3YXMgYWN0aXZlLg0KDQogPiBJZiB0aGF0IGlzIHRoZSBleHBsYW5hdGlv biwgdGhlbiBpdCBsZWF2ZXMgdXMgd2l0aCBmZXcgZ29vZCBvcHRpb25zLg0KID4gSSBhbSBu b3QgaW4gZmF2b3Igb2YgZGlzYWJsaW5nIGF1dG92YWN1dW0gaW4gdGhlIHRlc3Q6IG9yZGlu YXJ5DQogPiB1c2VycyBhcmUgbm90IGdvaW5nIHRvIGRvIHRoYXQgd2hpbGUgcGdfdXBncmFk ZSdpbmcsIHNvIGl0J2QgbWFrZQ0KID4gdGhlIHRlc3QgbGVzcyByZXByZXNlbnRhdGl2ZSBv ZiByZWFsLXdvcmxkIHVzYWdlLCB3aGljaCBzZWVtcyBsaWtlDQogPiBhIGJhZCBpZGVhLiAg V2UgY291bGQgZWl0aGVyIGRyb3AgdGhpcyBwYXJ0aWN1bGFyIGNoZWNrIGFnYWluLCBvcg0K ID4gd2Vha2VuIGl0IHRvIGFsbG93IG5ldyByZWxmcm96ZW54aWQgPj0gb2xkIHJlbGZyb3pl bnhpZCwgbGlrZXdpc2UNCiA+IHJlbG1pbnhpZC4NCg0KVGhlIHRlc3QgZG9lcyBsb29rIGhl bHBmdWwgYW5kIGl0IHdvdWxkIGNhdGNoIHJlZ3Jlc3Npb25zLiBMb29zZWx5IA0KcXVvdGlu ZyBSb2JlcnQgb24gYSBkaWZmZXJlbnQgcG9pbnQgdXB0aHJlYWQsIHdlIGRvbid0IHdhbnQg dG8gdHVybiBvZmYgDQp0aGUgYWxhcm0ganVzdCBiZWNhdXNlIGl0J3Mgc3B1cmlvdXNseSBn b2luZyBvZmYuDQoNCkkgdGhpbmsgdGhlIHdlYWtlbmVkIGNoZWNrIGlzIE9LIChhbmQgcG9z c2libHkgbWltaWNzIHRoZSByZWFsLXdvcmxkIA0Kd2hlcmUgYXV0b3ZhY3V1bSBydW5zKSwg dW5sZXNzIHlvdSBzZWUgYSBtYWpvciBkcmF3YmFjayB0byBpdD8NCg0KSm9uYXRoYW4NCg== --------------S07L8D1xY1UjpGEtbd020b0q-- --------------6nIvKogOfIKBfuyr1eXE71Y4 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/x8QSccp8cZScFAmLpfqgFAwAAAAAACgkQ8QSccp8cZSc8 uxAAm2cxfXaZ1QQnxHO+e+/Fzksl8hn2FpNAnfjqYglnRahWZZQ2bGr90Snrv0qJsh2LnhMJMwQS jE0swBnhOBQJjMbomo6Ls4MfB/sHulxIzHVJy1YGhN535O2VvQBf3PldPhJTYv0WZZJQ5q+0DlGp AHZpvfylcj0CAcZt/hQMdBs+mMk8IuY1eEQV89L51tncpNNEKn/JlFiQxE52taEaxWbUdFbZXImT GLDImDXdDxJXYI1A3jgMwBEoCTXz3iaFTgMsDho1TtuycVuKGo2Lb2oENNbaf8oPV78W3CWq/09f eDM27Pbbp7VaLH1EYyRtwlp/5sr3a4YuVkFn9MT6mohG2C9JB2Q8CHVpaqFb6X+puRPV+2f6L7PS nWwgRagF+LeOJmun42yNd7oYkwY13TSmygI/qWWT5UVtPfH6+k7raUu6hST6/Vt9oxngkZEelY2S VQgExjE+sXdVQTRN83LiFQq8AYAp7v7OFdTNmYEO3VSm7J/3NSzFJB4K7rQZC5EKl41jiW9v8+Kx aBCjFVuDL2seuCFttvDyyAjUcYnQKVprlvlsTehbtjz+DXDQ2xqMQpqhmkICAw3xUzGb3X2a48S2 Go9BPj2uSd5rSuah6cbAKWX5rFqeEIX/kQitz5kFi+k+qmRQzf5J7vW6g7quY5xgPpgPpML3vtXw T94= =RBR8 -----END PGP SIGNATURE----- --------------6nIvKogOfIKBfuyr1eXE71Y4--