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 1m4QaW-0004jW-Gz for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 16:21:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4QaV-0005wJ-Gm for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 16:21:19 +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 1m4QaV-0005vb-3C for pgsql-hackers@lists.postgresql.org; Fri, 16 Jul 2021 16:21:19 +0000 Received: from mail-bn8nam12on2064.outbound.protection.outlook.com ([40.107.237.64] helo=NAM12-BN8-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m4QaN-0001fW-7k for pgsql-hackers@lists.postgresql.org; Fri, 16 Jul 2021 16:21:18 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=llLybiEB4wW0svNYdtoicGBYnvcUPDpMvegvAw7CjgFY3JrvzKGa9PBvubULGc+QCmYzRN1KY8JDw/cR2ZMSOIaK81UDTk8RrjRmo/c3I0G6E0x1BhYTytv3C0qbi1fH738mxoU08tWxB9z8og/2dtc+QqZtBmfFX15nvRDye3aupzANm1DGEFtgOAfRh0PCumMKifTWzZNWVecSRW1oxtwcFgKCs8In2u0tWCogq/H0rjumiCkx5FLS3ZNSiw19pTD/WRR4pgyNmMA9wXjbMv2biMC71FWSrKt1Sj9r38evWbRKL1dbsxrKqRW3g1lXI/mYR9IPJsgrr6XE3o/aVg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=veam+O/3L4jUtUE2basGp+NJ3yjiOAdoYljmxXvo4uc=; b=PoUDT6qhR7IQ23e91vASu+hur3rJbgqne5X4XSpW1olepcvNj0aQAclpCjMYLmuP9rSlBW37477eaNt0u3be8cBbne/2ZBF7RjzMw+TFOrJNRe6wTeIg53LP6TzTi2CIdnjinbjAcMudEAx35R8hwSHJc8ZriAnjgRq1sqZSA5rov6/lcaxkVCg61v7+jPBsnTTHwTU7ZVGCexwBF5/aw/Wb3n85Z1g3jSbuW0k/Hqh+HHtgsgih/zMqoTySQVECr4hlY/3D4C1h7nkLtMVDiLljGXWpv1lePJ6Pkmk1L4wKge5P7HJy1+NEjB74PgWtzta/L4rjI6mhzZKgUKhbgA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=vmware.com; dmarc=pass action=none header.from=vmware.com; dkim=pass header.d=vmware.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vmware.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=veam+O/3L4jUtUE2basGp+NJ3yjiOAdoYljmxXvo4uc=; b=kAv2oJS7Is5hmwstoSFxYt4vWx+y6dg3ugsPmGiFQ8dm3RdPXVtw3b1iB9GEqsbyxflcmPwvy8aAe3il7bTp8VymZEYdumGlR6j4cX8El/JHc6u8FpxXYUIp9ds8wc48TtGNnIKPU/73l83GrbdUSpIdDc4osachnsgyxXJBOns= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by MWHPR05MB3215.namprd05.prod.outlook.com (2603:10b6:300:b1::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4352.8; Fri, 16 Jul 2021 16:21:07 +0000 Received: from MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::59e1:5f08:31c6:1d3]) by MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::59e1:5f08:31c6:1d3%9]) with mapi id 15.20.4352.011; Fri, 16 Jul 2021 16:21:07 +0000 From: Jacob Champion To: "pryzby@telsasoft.com" , "tgl@sss.pgh.pa.us" CC: "peter.eisentraut@enterprisedb.com" , "pgsql-hackers@lists.postgresql.org" , "buschmann@nidsa.net" , "andrew@dunslane.net" , "noah@leadboat.com" , "tomas.vondra@2ndquadrant.com" , "bruce@momjian.us" , "andres@anarazel.de" Subject: Re: pg_upgrade test for binary compatibility of core data types Thread-Topic: pg_upgrade test for binary compatibility of core data types Thread-Index: AQHWy/oTTr5TiqKsCkO4HbbPWLsyjqn6CBSAgBFnAoCAF0TsAIAA5rUAgADahYCAAANTgIAAB0gAgABAaQCAA9DJgIBPXhGAgFZXqQCAeN5wAA== Date: Fri, 16 Jul 2021 16:21:07 +0000 Message-ID: References: <20201216172222.GS30237@telsasoft.com> <20201227190729.GB26311@telsasoft.com> <20210112041352.GY1849@telsasoft.com> <20210112171559.GO4320@momjian.us> <20210112172753.GC1849@telsasoft.com> <20210112175356.GP4320@momjian.us> <66753439-83ae-7be5-6e41-9537a6041a39@dunslane.net> <1575064.1615060903@sss.pgh.pa.us> <20210430183348.GQ27406@telsasoft.com> In-Reply-To: <20210430183348.GQ27406@telsasoft.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Evolution 3.36.5-0ubuntu1 authentication-results: telsasoft.com; dkim=none (message not signed) header.d=none;telsasoft.com; dmarc=none action=none header.from=vmware.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 7521d8b5-ed16-42d8-1e95-08d94875b75f x-ms-traffictypediagnostic: MWHPR05MB3215: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:10000; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 26R3sy3zCDotUssR/XNwA2ucRrtwMWG3QGtOfI+zftE5L722FIdiMUECq9GYo6UjltM3tAcyK6ZeoIOBhLBzjJ+Tuoh1OfFhfSGQvwoHipNeeDxS46fk1t9oFpL4rFHVCesYNVxmiBHwGIhmE6tRncVBbr14PF7l7DidNNdIFfyK2dPPVXzNf9CG62RD/BxdF7X3si+BCOkmfRz6F2UcfXrWxCzVkRBh9Tk57YN+U5TX21jDjl4jv2lWLH+njswJtgwxhupWDqJqj7PlAuXapGhjGaUTZw1LO9MCWXeM2nS/UCzmpsmLTc8+URxkqBSrOjpgic6zwi0+6PMwrt1p8F3y08/+gcrW+xjuEmd/IZswKOxtdoySzhuFMYRIV8ZVQo/kcDHrMoZXtHVv2m5I/74DpL4hNWZQm5S1+9j2CVVON/uoPdRhpjtvoxfWj7CfBXtCSnhc48yOH7Gp7VLlNSXzH3QeilcFJiBCCYRMXaVubyareaTt4wbSmagsPqn/9FMtf+JevI53F/gasJQ3j+gAfz+pQ+0RQd8W5k3lplXqVZxUtsW6xdJiB2ABJuRs3bZhC+ZYp9dEgtxe3Z75SITr1Y6KCf1YD8EXOWkYNacViCDx2fO1O+Ls500DTdN3f3vtIsKw21/2FY3+NHM9y95V9ZAFZ0+yTvzz7nhRD+bmEQM6LiJkzt5UDNIhvTH2ChiXAJiwHfnxUjFfvrWHFA== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:MWHPR05MB2896.namprd05.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(64756008)(508600001)(54906003)(316002)(71200400001)(110136005)(36756003)(26005)(8676002)(66476007)(66446008)(8936002)(186003)(5660300002)(6506007)(38100700002)(66946007)(86362001)(6486002)(4326008)(2616005)(76116006)(122000001)(6512007)(2906002)(66556008)(7416002)(38070700004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?LzVHOUs0dkdOYlB0SmVTVnArQkhPOWV4UUkzalozWmpCdi85QlA1R2JKVkh4?= =?utf-8?B?MktIM2J2WUFSazhjVnB6ck9kcjd4eHA1anRsNlpYRjczdnZGalRLbmJQN0N3?= =?utf-8?B?cVRrVmVJYkltNzlvTEVKZWE0bDZ4RElOQnYwUVFuRzI5L0lXWHdGRkdyVFdk?= =?utf-8?B?NGc2QTZQRURBbC92aTRiOWhib0ZQa3AwOElqbHRjNjNPZ0NwbC9QT1VHUUVN?= =?utf-8?B?aEFybVlETUFwbGhtaTlyQ1FubTdTUTg4bG9pa0c5K3B4NlVJdVBlVGFtbis5?= =?utf-8?B?UmZTNXl0SHVpaG9xdEZtYlgzMWtXc2dLVVF3QndMdGZuQmJYT1gyV3F4MmdG?= =?utf-8?B?Mkc3NEtiOE5JcEpqM3lkU0RYUEQ0aE82c0FMWHArYkhzbmpLZ0JWeDZab25D?= =?utf-8?B?Zzh5UEFOZ3JvYzZUcEVSSUVmeE9FcWZCQ21tQVRmZmVXdnB6K0JuYy9IblBV?= =?utf-8?B?dnJJTjQwazBWUzJTTzdsdjBVS2NrbEFFVjYzY2x5UVVNUjNpWVl0RU8wZUk0?= =?utf-8?B?SWkxU2xVKzAycU81Y2Vhd0dVL1hkdWQrNDZxYTVxMXhCdWRwcGNaUk9MVmZa?= =?utf-8?B?Sk1XSitRa2lVbk02SE5WQlBwTXBwd0x5UVdiNitkRGxqUVNTVHlKSXBlWlpj?= =?utf-8?B?NjhNeGVLUEtFMTdkSVRIbjNUUHZieHkvdDJDTzR2ZE1sTXExV25UVTJhNDVs?= =?utf-8?B?dmtOTGhQNGZmcmFPZ3ZlK1pDcy9rZUI5bXQ0OGFhYlFxT0lPV1JZbUd6U0VI?= =?utf-8?B?Z1VTaXNkcHk0VU9Za3ltMklCUnVRaG40cnpqZzZEbXFqOVhNL1A3N0d5WlZP?= =?utf-8?B?MWhvMU9kUjlwZjVGQzZ2YWxpQW5jK1M4T3NaQjFNTXU4bXZzTi8xWmtyeXl0?= =?utf-8?B?Q05YRCtYWXE1S0hYRmZCVUpTUlUyR2QzSk8rRFYvQmd1ei9sbjVYZGU3T1hQ?= =?utf-8?B?bmE3VmJvb3l6SjhOYmIrWkRVeGNDck91QU4vQUlQSjdJK1lGK2xqYTVPc0Uv?= =?utf-8?B?S1ZEQ0xRZkVSTm5vWUVUVzM1VmFUUEpYeWRJbmx2eDVkN1pvMDIrM3RuVzVV?= =?utf-8?B?UHptak5ZY0E3bnM2SE1MV0dvY0g0aHdsWXppRnJ4RjMwcnEyVWE0bGUweGZ1?= =?utf-8?B?aWZpSFVsSk1QSEVGR2pTU2srVm8xMDhYcGQ4SXhiMXNQdTc5R01Dd1UycE5G?= =?utf-8?B?MVZjNFU1U01XWFZLdjRIQjFDU1ZtZzRFUWtYVlVZalRNOXNGOVprcDE3WnVB?= =?utf-8?B?QVBTNnl1Rjh2VGxGWk1KU1ZnMmhBWE9GZkI2WVFlcFdFK2NNVTEzNFJyZUZG?= =?utf-8?B?VGZ5U0diS2dURXBvOG5oMHdwaEhENk9CUlVTSjFMK0Nyc0h2Z1JNdXhoODFr?= =?utf-8?B?QnBxVU9FVktmclc3WnlOREYrVU1PN3RVNkNFajQ3bFM4d0V3VmttZ0JYN0Vm?= =?utf-8?B?KzZmYWZFcDFCajZSMUpPOUoyS0s0YmsvV1MzK1NHZWhvZkFGNlZBNzd2Mm54?= =?utf-8?B?eS8wVTlJdXg3YS82Uy9DUURBUEdiei83TkpHSEpNVlFvaC9HMDFaOHY0ZCsv?= =?utf-8?B?VXh6TEkrdlNaa2dINlJxdDV2OWdhb0wyWUgvU1pQM0hBcFEwU1d0WklycHdK?= =?utf-8?B?WXA2ZEtzUm13SGRMYUNmQUxvcjg1cVR6NEd0WHh3MmdjTzRPaUZYZS8xeW1v?= =?utf-8?B?Ynp4MXIraHE5Rkk0anJERk53RVQxemFDVXRMcENOYjFWcG11blQ3dHVreWt1?= =?utf-8?Q?HaN90ONDi+oOjEKwI+TCbpVnp/dj5IhDJfk2qdR?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: vmware.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: MWHPR05MB2896.namprd05.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 7521d8b5-ed16-42d8-1e95-08d94875b75f X-MS-Exchange-CrossTenant-originalarrivaltime: 16 Jul 2021 16:21:07.3853 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: b39138ca-3cee-4b4a-a4d6-cd83d9dd62f0 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 43WEcI2Ks4YW2aDvoDYoEYv8ovVNyemc0UX3UMkHrpHag6Wwqs/CQmIZGuwsfa0FBEz/e+QJ+pKLLyI1wCME7w== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR05MB3215 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpLCAyMDIxLTA0LTMwIGF0IDEzOjMzIC0wNTAwLCBKdXN0aW4gUHJ5emJ5IHdyb3RlOg0K PiBPbiBTYXQsIE1hciAwNiwgMjAyMSBhdCAwMzowMTo0M1BNIC0wNTAwLCBUb20gTGFuZSB3cm90 ZToNCj4gPiB2NC0wMDAxIG1vc3RseSB0ZWFjaGVzIHRlc3Quc2ggYWJvdXQgc3BlY2lmaWMgY2hh bmdlcyB0aGF0IGhhdmUgdG8gYmUNCj4gPiBtYWRlIHRvIGhpc3RvcmljIHZlcnNpb25zIG9mIHRo ZSByZWdyZXNzaW9uIGRhdGFiYXNlIHRvIGFsbG93IHRoZW0NCj4gPiB0byBiZSByZWxvYWRlZCBp bnRvIGN1cnJlbnQgc2VydmVycy4gIEFzIGFscmVhZHkgZGlzY3Vzc2VkLCB0aGlzIGlzDQo+ID4g cmVhbGx5IGR1cGxpY2F0aXZlIG9mIGtub3dsZWRnZSB0aGF0J3MgYmVlbiBlbWJlZGRlZCBpbnRv IHRoZSBidWlsZGZhcm0NCj4gPiBjbGllbnQgb3ZlciB0aW1lLiAgSXQnZCBiZSBiZXR0ZXIgaWYg d2UgY291bGQgcmVmYWN0b3IgdGhhdCBzbyB0aGF0DQo+ID4gdGhlIGJ1aWxkZmFybSBzaGFyZXMg YSBjb21tb24gZGF0YWJhc2Ugb2YgdGhlc2UgYWN0aW9ucyB3aXRoIHRlc3Quc2guDQo+ID4gQW5k IHNhaWQgZGF0YWJhc2Ugb3VnaHQgdG8gYmUgaW4gb3VyIGdpdCB0cmVlLCBzbyBjb21taXR0ZXJz IGNvdWxkDQo+ID4gZml4IHByb2JsZW1zIHdpdGhvdXQgaGF2aW5nIHRvIGdldCBBbmRyZXcgaW52 b2x2ZWQgZXZlcnkgdGltZS4NCj4gPiBJIHRoaW5rIHRoaXMgY291bGQgYmUgcmVwcmVzZW50ZWQg YXMgYSBwc3FsIHNjcmlwdCwgYXQgbGVhc3QgaW4NCj4gPiB2ZXJzaW9ucyB0aGF0IGhhdmUgcHNx bCBcaWYgKGJ1dCB0aGF0IGNhbWUgaW4gaW4gdjEwLCBzbyBtYXliZQ0KPiA+IHdlJ3JlIHRoZXJl IGFscmVhZHkpLg0KPiANCj4gSSBzdGFydGVkIHRoaXMuICBJIGRvbid0IGtub3cgaWYgaXQncyBj b21wYXRpYmxlIHdpdGggdGhlIGJ1aWxkZmFybSBjbGllbnQsIGJ1dA0KPiBJIHRoaW5rIGFueSBp c3N1ZXMgbWF5YmUgY2FuIGJlIGF2b2lkZWQgYnkgdXNpbmcgIklGIEVYSVNUUyIuDQoNCkknbSBn b2luZyB0byB0cnkgcHVsbGluZyB0aGlzIGludG8gYSBwc3FsIHNjcmlwdCB0b2RheSBhbmQgc2Vl IGhvdyBmYXINCkkgZ2V0Lg0KDQo+ID4gQnV0IEknbSBub3Qgc3VyZSBJIGJlbGlldmUNCj4gPiB0 aGF0IHF1ZXJ5LiAgSXQncyBnb3QgaGFyZC13aXJlZCBhc3N1bXB0aW9ucyBhYm91dCB3aGljaCB0 eXB0eXBlIHZhbHVlcw0KPiA+IG5lZWQgdG8gYmUgY292ZXJlZC4gIFdoeSBpcyBpdCBva2F5IHRv IGV4Y2x1ZGUgcmFuZ2UgYW5kIG11bHRpcmFuZ2U/DQo+ID4gQXJlIHdlIHN1cmUgdGhhdCBhbGwg Y29tcG9zaXRlcyBhcmUgb2theSB0byBleGNsdWRlPyAgTGlrZXdpc2UsIHRoZQ0KPiA+IHJlc3Ry aWN0aW9uIHRvIHBnX2NhdGFsb2cgYW5kIGluZm9ybWF0aW9uX3NjaGVtYSBzY2hlbWFzIHNlZW1z IGxpa2VseSB0bw0KPiA+IGJpdGUgdXMgc29tZWRheS4gIFRoZXJlIGFyZSBzb21lIHZlcnkgcmFu ZG9tIGV4Y2x1c2lvbnMgYmFzZWQgb24gbmFtZQ0KPiA+IHBhdHRlcm5zLCB3aGljaCBzZWVtIHVu c2FmZSAobGV0J3MgbGlzdCB0aGUgc3BlY2lmaWMgdHlwZSBPSURzKSwgYW5kDQo+ID4gYWdhaW4g dGhlIG5lYXJieSBjb21tZW50cyBkb24ndCBtYXRjaCB0aGUgY29kZS4gIEJ1dCB0aGUgYmlnZ2Vz dCBpc3N1ZQ0KPiA+IGlzIHRoYXQgdGhpcyBjYW4gb25seSBjb3ZlciBjb3JlIGRhdGF0eXBlcywg bm90IGFueSBjb250cmliIHN0dWZmLg0KPiANCj4gSSBjaGFuZ2VkIHRvIHVzZSByZWd0eXBlL09J RHMsIGluY2x1ZGVkIHJhbmdlL211bHRpcmFuZ2UgYW5kIHN0b3BwZWQgaW5jbHVkaW5nDQo+IG9u bHkgcGdfY2F0YWxvZy9pbmZvcm1hdGlvbl9zY2hlbWEuICBCdXQgZGlkbid0IHlldCBoYW5kbGUg Y29tcG9zaXRlcy4NCg0KUGVyIGNmYm90LCB0aGlzIHRlc3QgbmVlZHMgdG8gYmUgdGF1Z2h0IGFi b3V0IHRoZSBuZXcNCnBnX2JyaW5fYmxvb21fc3VtbWFyeSBhbmQgcGdfYnJpbl9taW5tYXhfbXVs dGlfc3VtbWFyeSB0eXBlcy4NCg0KLS1KYWNvYg0K