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 1oIyOd-0001Ed-0V for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 20:21:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIyNd-0001th-8v for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 20:20:41 +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 1oIyNc-0001tY-Us for pgsql-hackers@lists.postgresql.org; Tue, 02 Aug 2022 20:20:40 +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 1oIyNY-0004BL-6F for pgsql-hackers@postgresql.org; Tue, 02 Aug 2022 20:20:40 +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:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=6xSyieZpOZS86saCxvdAOttj7RFcCLntMpxQpibQVF0=; b=EMHaASe8qHdipCl1PVWevd2B7i OPwQL5UYNpWgtU9QKmDhQsXpSaVIxUY6VBorPLjlOorHck6IHAIFE61I5f7cFfEkEwvDvOoLzlW/T +j7EHr2Fr+5AfAY0LM5mg/ESBcgvvq1NmWA++NktKFxWlIuIgLLf3xVh7u/j/aTkksNuaBr/kFd0z //eMZ0Ntlji7asX6RTaJcYjJ3sqbv2evC+i9WgBSHQAT2SjmmKGa5XjMsSA+n7Edrn1e4ODcDZy6D PGLWqnJO0apPtlsTBKQnRmg7PGs7lL081UwjgLXv8WKkPRpd+rzq7E9GvRLvcaBiy5TDWJW7S2WuZ uebeUhCQ==; 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 1oIyNS-0003Dd-3r; Tue, 02 Aug 2022 20:20:32 +0000 Message-ID: <06f74ad5-9e28-85ae-35ae-cbb6a2d756b8@postgresql.org> Date: Tue, 2 Aug 2022 16:20:25 -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 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> <98286e9b-8fe6-554e-c23f-d67a3df2c30d@postgresql.org> <2687956.1659469881@sss.pgh.pa.us> From: "Jonathan S. Katz" Subject: Re: pg15b2: large objects lost on upgrade In-Reply-To: <2687956.1659469881@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------iQdh8ERp2ZZiLv2k7N4jPw2w" 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) --------------iQdh8ERp2ZZiLv2k7N4jPw2w Content-Type: multipart/mixed; boundary="------------JVc84y5BmLx9ZOyDUzZiqe6H"; 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: <06f74ad5-9e28-85ae-35ae-cbb6a2d756b8@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> In-Reply-To: <2687956.1659469881@sss.pgh.pa.us> --------------JVc84y5BmLx9ZOyDUzZiqe6H Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8yLzIyIDM6NTEgUE0sIFRvbSBMYW5lIHdyb3RlOg0KPiAiSm9uYXRoYW4gUy4gS2F0 eiIgPGprYXR6QHBvc3RncmVzcWwub3JnPiB3cml0ZXM6DQo+PiBPbiA4LzIvMjIgMzozOSBQ TSwgVG9tIExhbmUgd3JvdGU6DQo+Pj4+IEkgYW0gbm90IGluIGZhdm9yIG9mIGRpc2FibGlu ZyBhdXRvdmFjdXVtIGluIHRoZSB0ZXN0OiBvcmRpbmFyeQ0KPj4+PiB1c2VycyBhcmUgbm90 IGdvaW5nIHRvIGRvIHRoYXQgd2hpbGUgcGdfdXBncmFkZSdpbmcsIHNvIGl0J2QgbWFrZQ0K Pj4+PiB0aGUgdGVzdCBsZXNzIHJlcHJlc2VudGF0aXZlIG9mIHJlYWwtd29ybGQgdXNhZ2Us IHdoaWNoIHNlZW1zIGxpa2UNCj4+Pj4gYSBiYWQgaWRlYS4gIFdlIGNvdWxkIGVpdGhlciBk cm9wIHRoaXMgcGFydGljdWxhciBjaGVjayBhZ2Fpbiwgb3INCj4+Pj4gd2Vha2VuIGl0IHRv IGFsbG93IG5ldyByZWxmcm96ZW54aWQgPj0gb2xkIHJlbGZyb3plbnhpZCwgbGlrZXdpc2UN Cj4+Pj4gcmVsbWlueGlkLg0KPiANCj4+IFRoZSB0ZXN0IGRvZXMgbG9vayBoZWxwZnVsIGFu ZCBpdCB3b3VsZCBjYXRjaCByZWdyZXNzaW9ucy4gTG9vc2VseQ0KPj4gcXVvdGluZyBSb2Jl cnQgb24gYSBkaWZmZXJlbnQgcG9pbnQgdXB0aHJlYWQsIHdlIGRvbid0IHdhbnQgdG8gdHVy biBvZmYNCj4+IHRoZSBhbGFybSBqdXN0IGJlY2F1c2UgaXQncyBzcHVyaW91c2x5IGdvaW5n IG9mZi4NCj4+IEkgdGhpbmsgdGhlIHdlYWtlbmVkIGNoZWNrIGlzIE9LIChhbmQgcG9zc2li bHkgbWltaWNzIHRoZSByZWFsLXdvcmxkDQo+PiB3aGVyZSBhdXRvdmFjdXVtIHJ1bnMpLCB1 bmxlc3MgeW91IHNlZSBhIG1ham9yIGRyYXdiYWNrIHRvIGl0Pw0KPiANCj4gSSBhbHNvIHRo aW5rIHRoYXQgIj49IiBpcyBhIHN1ZmZpY2llbnQgcmVxdWlyZW1lbnQuICBJdCdkIGJlIGEN Cj4gYml0IHBhaW5mdWwgdG8gdGVzdCBpZiB3ZSBoYWQgdG8gY29wZSB3aXRoIHBvdGVudGlh bCBYSUQgd3JhcGFyb3VuZCwNCj4gYnV0IHdlIGtub3cgdGhhdCB0aGVzZSBpbnN0YWxsYXRp b25zIGhhdmVuJ3QgYmVlbiBhcm91bmQgbmVhcmx5DQo+IGxvbmcgZW5vdWdoIGZvciB0aGF0 LCBzbyBhIHBsYWluICI+PSIgdGVzdCBvdWdodCB0byBiZSBnb29kIGVub3VnaC4NCj4gKFJl cGxhY2luZyB0aGUgc2ltcGxlICJlcSIgY29kZSB3aXRoIHNvbWV0aGluZyB0aGF0IGNhbiBo YW5kbGUgdGhhdA0KPiBkb2Vzbid0IGxvb2sgbGlrZSBtdWNoIGZ1biwgdGhvdWdoLikNCg0K Li4uaWYgdGhlc2Ugc3lzdGVtcyBhcmUgaGl0dGluZyBYSUQgd3JhcGFyb3VuZCwgd2UgaGF2 ZSBhbm90aGVyIGlzc3VlIHRvIA0Kd29ycnkgYWJvdXQuDQoNCkkgc3RhcnRlZCBtb2RpZnlp bmcgdGhlIHRlc3QgdG8gc3VwcG9ydCB0aGlzIGJlaGF2aW9yLCBidXQgdGhvdWdodCB0aGF0 IA0KYmVjYXVzZSAxLiB3ZSB3YW50IHRvIGVuc3VyZSB0aGUgT0lEIGlzIHN0aWxsIGVxdWFs IGFuZCAyLiBpbiB0aGUgDQpleGFtcGxlcyB5b3Ugc2hvd2VkLCBib3RoIHJlbGZyb3plbnhp ZCBvciByZWxtaW54aWQgY291bGQgaW5jcmVtZW50LCB3ZSANCm1heSB3YW50IHRvIGhhdmUg dGhlIGluZGl2aWR1YWwgY2hlY2tzIG9uIGVhY2ggY29sdW1uLg0KDQpJIG1heSBiZSBhYmxl IHRvIGNvbmp1cmUgc29tZXRoaW5nIHVwIHRoYXQgZG9lcyB0aGUgYWJvdmUsIGJ1dCBpdCdz IGJlZW4gDQphIG1pbnV0ZSBzaW5jZSBJIHdyb3RlIGFueXRoaW5nIGluIFBlcmwuDQoNCkpv bmF0aGFuDQo= --------------JVc84y5BmLx9ZOyDUzZiqe6H-- --------------iQdh8ERp2ZZiLv2k7N4jPw2w 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/x8QSccp8cZScFAmLphwkFAwAAAAAACgkQ8QSccp8cZSeC GRAAglTknJwuqeotVMz+Vkj4qy5XX1CCBMVlvXaMDNxH+7rn2fHVhZqANqO9Ze9dSC/eTh+qNdoz fW1ANf8XUpiJRmH2hEkX4qcHppyYccqV1unpiYk4Fxp2i6M4LwqQj/JT4i6FpN6nbtdKxHWLxKdi UTmdGgR8pmJHbveI+DN/sqijQ2FXCNijDkvGIuu8M5v4INHO1DBixfXo4JJXdzI6AB8SCvzEwpI6 eDUFieZ6zR3gzsoO9iyhoN59CaApByAIYhXB6mdO2DTv6KLaZikP4goE0+lT7UoMETk4ACvJX7he Fa1g2a7q+WtgJbNJrl0p74XzNTLRJ9y3wGytTuR/NzLjWJjmwZLiSZicnpa8NJZNKxpbjXrXerZE 0/N1gQxLNyaFwPzdToJbapQSKTNy4d/Sup782Qum2C/DqHSGWHoXPMin4LzvSUHch4y4BryP9Gbl egC5peYH1WIUtUGxjD4Bc8BNykjz7j6O4+LXMpnQ3b1qoORBIj6q7b/+ddBEfMAqTHK+7OOF+jCn +48a4OFdFNeSC/7igsgAaFe0tnviX+CcYAOpbDxv1hQQsUL8Ha/sW0Wl0tuAOOr892O9zVjNPYMX 4G+FkXxJrKYrKVvruv7AZ+tmuhiAlXCqFphdHpcrMr72jrNH2Ap8Q+8eztn28T7ieHZsKpermV1Y YyE= =RYje -----END PGP SIGNATURE----- --------------iQdh8ERp2ZZiLv2k7N4jPw2w--