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 1oIxZh-0007K4-Dg for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 19:29:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIxYh-0003ri-2q for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Aug 2022 19:28:03 +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 1oIxYg-0003rZ-Pl for pgsql-hackers@lists.postgresql.org; Tue, 02 Aug 2022 19:28:02 +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 1oIxYe-0003eO-En for pgsql-hackers@postgresql.org; Tue, 02 Aug 2022 19:28:02 +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=10R13UTYfcu0iIH+jk/ss2pE7jgNj+gRXvyUWQSrXZY=; b=TSuqSyv8PBG44kuVWwhgGH/er2 3buyPxknrUsQDAwsVwHJSCUA81yQ0SdztSTNr6ywcvmRRIQ7uFD2inhWEo5RH3P4qWxg88fnvXFfo fX6yPYJwv2PetY7fm+IAEB6mSMPYcLCDATHt+Q+Rtd7yqowfsWvIB/DQznV+v0ymUapzHAfDfY59e 4XOZAIcmw9TWDTA9FXge1cnjNa6r4OGAl1UtUoBWIVOAeq7Ega0a6sML/lYMD4Jbpz6gtW3KB++Ie HjNPj0XjU6HIV2rvyEprhTKjTiv0ts8v4TiQUjBVVHwciJFmwbkzAd5T935H4/4L4zLK6pl1Bfztp XRlZMihA==; 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 1oIxYX-0002Tb-8V; Tue, 02 Aug 2022 19:27:55 +0000 Message-ID: Date: Tue, 2 Aug 2022 15:27:49 -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: Robert Haas , Tom Lane Cc: 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> From: "Jonathan S. Katz" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------kGYWjRK8yKK0ud7gpjuuQgtV" 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) --------------kGYWjRK8yKK0ud7gpjuuQgtV Content-Type: multipart/mixed; boundary="------------oiDUHa6XcbIzvkSG0eHxkZqd"; protected-headers="v1" From: "Jonathan S. Katz" To: Robert Haas , Tom Lane Cc: Noah Misch , Andrew Dunstan , Bruce Momjian , Michael Paquier , Justin Pryzby , "pgsql-hackers@postgresql.org" , Shruthi Gowda Message-ID: 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> In-Reply-To: --------------oiDUHa6XcbIzvkSG0eHxkZqd Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOC8yLzIyIDM6MjMgUE0sIFJvYmVydCBIYWFzIHdyb3RlOg0KPiBPbiBUdWUsIEF1ZyAy LCAyMDIyIGF0IDE6MTIgUE0gVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPiB3cm90ZToN Cj4+IE5vdCBzdXJlIHdoYXQgdG8gbWFrZSBvZiB0aGlzLCBleGNlcHQgdGhhdCBtYXliZSB0 aGUgdGVzdCBpcyB0ZWxsaW5nDQo+PiB1cyBhYm91dCBhbiBhY3R1YWwgYnVnIG9mIGV4YWN0 bHkgdGhlIGtpbmQgaXQncyBkZXNpZ25lZCB0byBleHBvc2UuDQo+IA0KPiBUaGF0IGNvdWxk IGJlLCBidXQgd2hhdCB3b3VsZCB0aGUgYnVnIGJlIGV4YWN0bHk/IEl0J3MgaGFyZCB0byB0 aGluaw0KPiBvZiBhIG1vcmUgZGlyZWN0IHdheSBvZiBzZXR0aW5nIHJlbG1pbm14aWQgYW5k IHJlbGZyb3plbnhpZCB0aGFuDQo+IHVwZGF0aW5nIHBnX2NsYXNzLiBJdCBkb2Vzbid0IHNl ZW0gcmVhbGlzdGljIHRvIHN1cHBvc2UgdGhhdCB3ZSBoYXZlIGENCj4gYnVnIHdoZXJlIHNl dHRpbmcgYSBjb2x1bW4gaW4gYSBzeXN0ZW0gdGFibGUgdG8gYW4gaW50ZWdlciB2YWx1ZQ0K PiBzb21ldGltZXMgc2V0cyBpdCB0byBhIHNsaWdodGx5IGxhcmdlciBpbnRlZ2VyIGluc3Rl YWQuIElmIHRoZSB2YWx1ZXMNCj4gb24gdGhlIG5ldyBjbHVzdGVyIHNlZW1lZCBsaWtlIHRo ZXkgaGFkIG5ldmVyIGJlZW4gc2V0LCBvciBpZiBpdA0KPiBzZWVtZWQgbGlrZSB0aGV5IGhh ZCBiZWVuIHNldCB0byBjb21wbGV0ZWx5IHJhbmRvbSB2YWx1ZXMsIHRoZW4gSSdkDQo+IHN1 c3BlY3QgYSBidWcgaW4gdGhlIG1lY2hhbmlzbSwgYnV0IGhlcmUgaXQgc2VlbXMgbW9yZSBi ZWxpZXZhYmxlIHRvDQo+IG1lIHRvIHRoaW5rIHRoYXQgd2UncmUgYWN0dWFsbHkgc2V0dGlu ZyB0aGUgY29ycmVjdCB2YWx1ZXMgYW5kIHRoZW4NCj4gc29tZXRoaW5nIC0gbWF5YmUgYXV0 b3ZhY3V1bSAtIGJ1bXBzIHRoZW0gYWdhaW4gYmVmb3JlIHdlIGhhdmUgYQ0KPiBjaGFuY2Ug dG8gbG9vayBhdCB0aGVtLg0KDQpGV0lXIChhbmQgSSBoYXZlIG5vdCBsb29rZWQgZGVlcGx5 IGF0IHRoZSBjb2RlKSwgSSB3YXMgdGhpbmtpbmcgaXQgY291bGQgDQpiZSBzb21ldGhpbmcg YWxvbmcgdGhvc2UgbGluZXMsIGdpdmVuIDEuIHRoZSByYW5kb21uZXNzIG9mIHRoZSANCnVu ZGVybHlpbmcgc3lzdGVtcyBvZiB0aGUgaW1wYWN0ZWQgZmFybSBhbmltYWxzIGFuZCAyLiBp dCB3YXMgb25seSB0aGUgDQp0aHJlZSBtZW50aW9uZWQuDQoNCj4gSSdtIG5vdCBxdWl0ZSBz dXJlIGhvdyB0byBydWxlIHRoYXQgdGhlb3J5IGluIG9yIG91dCwgdGhvdWdoLg0KDQpXaXRo b3V0IG92ZXJjb21wbGljYXRpbmcgdGhpcywgYXJlIHdlIGFibGUgdG8gY2hlY2sgdG8gc2Vl IGlmIGF1dG92YWN1dW0gDQpyYW4gZHVyaW5nIHRoZSBjb3Vyc2Ugb2YgdGhlIHRlc3Q/DQoN CkpvbmF0aGFuDQoNCg== --------------oiDUHa6XcbIzvkSG0eHxkZqd-- --------------kGYWjRK8yKK0ud7gpjuuQgtV 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/x8QSccp8cZScFAmLperUFAwAAAAAACgkQ8QSccp8cZSeK dw//ehTn6+wRwuVAdO843JbHoAFU5kfsOF9Kw20fU+LSEGHLoV0yxqv0UhHFjPef39j4UW8qXg6n Pmet9Qi0mSbaBx1reC1MCHzo4UkoFoB6H543lhKZUTkDZIsHIG/F4U3qADS54r4tAsEzqioin725 j2X+j93SrqpP5ehRuT6M90ZNfcjJPa5zDSvwc8QsKRt4JczfYcRYaieKJx9byCLdeUG+OlX31Alv GhKP/eESBN46uXc0LY6dWAbkw7j/DcQbbvwKEdLPyBB3Ce63xQfnCKrMwSNMyKMX+LbXiD5/vkVa MAENJTZ+V0XqjWr8qnAa/7DByaZv3/VbXHrEaWh/8n21C3vj9ZE9J9f+KcEQtj4Oi3P+TSikiPyY UB4UzfjiSw4FUlsEhHCsgQid0l0C/CvgXsK0x7Prr6wWHF1FWcLV7A+sMt/k5xZMhDdJTHQ/Wemv kP9KbKCecY10w+inUYfflffOPuLhU6pQ1z6mDQ1K6/bYXyEbrcOn5mifq8ueL6ehmgARxhINvzTk zX58A5z6mt7pQJKIIHXxxzP+cbrb3H86LUZzNJ0Tv+gy/AmoTvd+kDpBmJKmIISJIdzfBT4yoLVA FKY/csRraNxdNQxLw8dRB86bE5wdOBcjjGoeKTvX2wkYo2qlljyVVJzJmkG6amJxQCjpNWzi4CHh h6k= =uez/ -----END PGP SIGNATURE----- --------------kGYWjRK8yKK0ud7gpjuuQgtV--