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 1m4QtG-0005OP-CC for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 16:40:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4QtF-0007Er-Ca for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 16:40:41 +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 1m4QtF-0007Ej-07 for pgsql-hackers@lists.postgresql.org; Fri, 16 Jul 2021 16:40:41 +0000 Received: from mail-bn8nam08on2060.outbound.protection.outlook.com ([40.107.100.60] helo=NAM04-BN8-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m4QtC-0004wk-5h for pgsql-hackers@lists.postgresql.org; Fri, 16 Jul 2021 16:40:39 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=HwZBsnDqyE1rKS9i366iU/fovAyis7oHDeU0w8l4pXOrLmU7DUZxOtjWPd4c5AaRKgjzWqtrAHjPFU5mlSsIEPzfXldDvBTS8b2Zvm4f41qPy9ynu00tIa6XfbDbernlmI8h9AGQCBG86llzNhB4Iw9v0SQVTgIep3MOO6H4/iOVHxQXy1GtHv7Vs/OOll31/9FICnTr1NHiJhPWbSpP9vQc/RYmCa2DKe4Rd0YgTvsQGdxR6egdn05O8iZUdjDdIPDS5ekYUxYeVwKFG2kuFoMZIiJtn3lhiTXHREGWN516TX6KJYVYh7dy1BF54OSs5mVuBZhmsMCHqWdjRB1JwA== 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=BH220XxasH4+6eMdKEwKMjdHUXy72KSj1wp9EA81Cuk=; b=VHcGAGtgBssbqwX6LeZFY6fv0tPqPW+cWHFspKgZdFkFOYFDTLtHqppAjl2DqmlCUIClWy/6x4wJU5ryYB+rDY+1kNzSqCik9Q6bS71BoIbpz7Il5sWJ5AYZtj8iCJFo+azraK5hgCiEAuZzi+4VQRJ8aF7NYnv07pdCA+1UmPw2WFTn3mlFSUH7hMvmWho63MDXA7Pi+N/BLulDQboRN5HlQZeQNY+ZGvXhfQfY9GRzsC0nUeqT+0SDDZz+2WLZpwcC/QGrGP8drvag9IyaaQ+0BAoAsjNleni05+FHxskpHwDRrhA3/xlD1jdOd7vXrniJl5evmeKarLIfIwk4Ow== 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=BH220XxasH4+6eMdKEwKMjdHUXy72KSj1wp9EA81Cuk=; b=OBU2QUiY6V33elbuyaFsmeUg7PoQBT55J3Ec9GWTtSCh3Ek3gLSL4yo3deZLJKKcfddkvUsAqVpwjPbZ0qV3YPZFEQL1rhBlCQ+iAETrao+EJjyj3pzLqGE0gKj7fb+cHAKsGECbziQbSiEQI5edpnSZMTnBD0zsEc2bEFCvMTs= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by MWHPR05MB2813.namprd05.prod.outlook.com (2603:10b6:300:5b::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4331.14; Fri, 16 Jul 2021 16:40:35 +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:40:35 +0000 From: Jacob Champion To: "pryzby@telsasoft.com" , "tgl@sss.pgh.pa.us" CC: "pgsql-hackers@lists.postgresql.org" , "peter.eisentraut@enterprisedb.com" , "buschmann@nidsa.net" , "andrew@dunslane.net" , "noah@leadboat.com" , "bruce@momjian.us" , "andres@anarazel.de" , "tomas.vondra@2ndquadrant.com" 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/oTTr5TiqKsCkO4HbbPWLsyjqn6CBSAgBFnAoCAF0TsAIAA5rUAgADahYCAAANTgIAAB0gAgABAaQCAA9DJgIBPXhGAgFZXqQCAeN5wAIAABXEA Date: Fri, 16 Jul 2021 16:40:34 +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: 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: 19494600-b51a-44f7-30ec-08d948786f58 x-ms-traffictypediagnostic: MWHPR05MB2813: 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: zDGVPk2PVYmVfHo33XITpf3P+g4m8xhj1dXDcE+hqWMPfD9kM4QVj/9h3in90l9whaypLJpLI1KDSOfRdPbfFtvApiNf0JAIUjigs3h1pcoFeIT1MzO+9BGHQNYUpu/DxF9EhkJXcXyw70nAKF8qLIHaVnPPdkQQxJg57cTISBcapDzEGB2Sn4dTaiq8SsZKEN1gTc4daFeGZ5lWynWwFK/AH/1WWIKUGrWGdi4aRtRaR8rQAXXGnYISzP2WgZDADbp0WO+pTzIaThluEkbyOEoiIZxZ5gl+cG3JGLXDjH+JOJysD2tlAktEgQhcCuEGiQkckMU/3CcOFK+Q+3hv10gUDRrerKfYL/H56wxqUnrBCdB2ok+kaDuQOy+wq7der1oN9WpZAzaDyOnIQ3sen3MreyfAB8bXtmbFbgpI5N9yutBM+1tZxI2fMeDH6J8jlta0+8Q9d2gXvYvLhShmfra49TU5l7u6Lu189omtxqMtk7VfenI/mh2Gy+2MmgS9BfTEizQHGoBKw/D75aQXdcUd3F5NbBby6teT6EkBsJ0Z962fta2L0Xf5u3SLT6k0EWGXUEFcNogE3gLquPFJ8zJyaBYnZ04VVoHXrfyFZ9C3Ov8A1L3wQJNezks4u5ku7+N3LPjy7ThOEKBep4QT4r2jZrpF1Bf54k2DvJFoJSiIM9kl70S48oc/QuoCGUaQ9lkfKEyxawqPiy1RiU5+AA== 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)(6486002)(66556008)(76116006)(6506007)(66446008)(64756008)(54906003)(2906002)(316002)(66476007)(66946007)(8936002)(110136005)(26005)(36756003)(508600001)(186003)(122000001)(6512007)(71200400001)(4326008)(38100700002)(5660300002)(86362001)(2616005)(7416002)(8676002)(38070700004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?UXVoRWF5cGpHMG5mSFZNYW1CNmQ4bi9ScTFkaXRpbnRlYStrZC9XM3ZXU0FJ?= =?utf-8?B?d1hCK05HekhTck1JVnovdk9kWGhSSUhLVGVnWFRqdlNpWWFxTDhId0dSL1pY?= =?utf-8?B?Y005bWtkQ29jLzRMZmZSZlJQNExCNndnWllmSStZbVFoa01IQkMwTXVLNVNi?= =?utf-8?B?bmgvTjlvUGg1UmRZWmFsTTRGOFhpRCsyOVFKNlhON0lhc1UxNGVPaFpwa3ZB?= =?utf-8?B?c1NvR2JuVG5TcjdvakdSTHFoZndzODQvWFA2T01nS1ZiYmtCYjZ1U2FML1dO?= =?utf-8?B?SDBNdGNBZ3hyR2FGQkVBNGlWNGNiVXFSdGNhYnhFdEgvSzZyQUJWbDNUMnlF?= =?utf-8?B?T2lHOWdaazBFTlo1a0RWVVZwbzJlWHY3L2drb1lERW44U3Y2TVFHS04xbW9Q?= =?utf-8?B?cnc4M0Z2RHk0OFlTRXE4ZVVaVER1SHE5SmFrOUNIVlVkTVprMkRmTlVrMVBx?= =?utf-8?B?YlM0a01KOFVjdVQ2TkdmSC90c0NpNmtDNDBuUHFrTWY3YTgzSXB1WEhJVjBy?= =?utf-8?B?UjA5Z3dnSWg1dFNtNnFibnRMeG9tM0REV3ppSzBzMGRRUUFrVUpoc2hnc1Y1?= =?utf-8?B?UFBLSVZOdDRFYWc3clhPL2MrT2dSLzlMM1ZjaHh1aVlrVDVMcmJhRWRtN1ZL?= =?utf-8?B?bTdFcVZrSkthZWNqYWoxUUdBOEtsZXFaMFVQNU0zdkJKRUxsNmYvbnFCa1la?= =?utf-8?B?K0tMb2w0VGViWHNmdWhxYldWYzZJYjZZYjdXMkJJZkgxREtoQnVxeCtYRm5J?= =?utf-8?B?UEJwK3RaSG9wNFllRU14elJydW1IeWxlV3d1bnBCL2s0N0h0dHVYU1M2TGwx?= =?utf-8?B?OXNkdWVaK1JhRnhBRzFqa0NOVWJyZEQ0VzdtbFEyeEthZlVHMmdRSGNUMVk1?= =?utf-8?B?ZjlMY3JNcXdsZys1RDEzMVJ5ejBsUHFteENTeU5tQ3dadzROdnNzWVhYQXZu?= =?utf-8?B?M1ZSakROcEZBMTlOOW5KMmlLdEhaaSs3MlAyWEZlS3dVVjJWSytSaHVBK2lz?= =?utf-8?B?dDhNekNwUFh3OExWQzBWRkgrWTkrY01mU1RGMmlEUkI0RmRGV1M4OXNCcWUv?= =?utf-8?B?TG0wQkJIUEc3c09tN1gxcnZrUlI1SDNwSG1OUTNDeUUwWTM3OUFHeTVTUkJR?= =?utf-8?B?eWdPSUd5RFc2b3UvcW41a3M5d3VvU0kvbUJlbU1Mem9tVFFzUWV0bURCaytI?= =?utf-8?B?TzRCQjRBUHkwUEdQdm9xZVZhRzFPcjFTei92NEVYM0IzSFNiYUkrWlFqNWpX?= =?utf-8?B?MkFwSHpQdVJDVlhWdnlNRHdYd2x0YzVYWFJKT25sTkhsRklSbURFN3JZNFJ3?= =?utf-8?B?Z3lZWHJOMWp4ekpFQVp3Q3J5V1RHdXROeUM2cFNXTHQ0WGEyalFpMnJtbTd2?= =?utf-8?B?VEZKa2pBV2dSMGR6cGlEcDE1dzIxcnVHN3FjU05iV0FMM3RWcElGejgzNlY3?= =?utf-8?B?U21kSTlkZ1VGdVhyS0pTdFNNb21ZSFUyQ3hXdUNldjdVZy9mcnd0VXJsbXR3?= =?utf-8?B?RzNvWUNJL2NaZDRZemRFZXRxNTEyNDRWUVBZRjU0MitQMTNIOUF3OE42UVlR?= =?utf-8?B?WnF2N29FTWJrRmYxblQ4M2ZQWVBNUjBhWkQ5OENQUlhia0laRElUM1ZtWGwy?= =?utf-8?B?ekpKR0piQU83Tk12cXhtRzdHZ2dMVTF3WGRaOVVVWHU0eVEvb1F2czRzVDhB?= =?utf-8?B?Ump5d3ZMMWRDcnZ4d1BoZnJzdzVrN3NrZG5SVVFFakNFZ3lVcGNlWEZRNnI4?= =?utf-8?Q?j6U0Iz+5u2/2b8ivMN+UEA1Z6OLxlXm1UNVcn5s?= 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: 19494600-b51a-44f7-30ec-08d948786f58 X-MS-Exchange-CrossTenant-originalarrivaltime: 16 Jul 2021 16:40:34.9572 (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: PJVRA6IUFWPjWS0Be/ZK0UpQjVjFOWOoGx+UPSvlOY4f8xlYrWBSc6AvAkpdM2pVEgQSKXodShNqvUmSWW72ig== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR05MB2813 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpLCAyMDIxLTA3LTE2IGF0IDE2OjIxICswMDAwLCBKYWNvYiBDaGFtcGlvbiB3cm90ZToN Cj4gT24gRnJpLCAyMDIxLTA0LTMwIGF0IDEzOjMzIC0wNTAwLCBKdXN0aW4gUHJ5emJ5IHdyb3Rl Og0KPiA+IE9uIFNhdCwgTWFyIDA2LCAyMDIxIGF0IDAzOjAxOjQzUE0gLTA1MDAsIFRvbSBMYW5l IHdyb3RlOg0KPiA+ID4gdjQtMDAwMSBtb3N0bHkgdGVhY2hlcyB0ZXN0LnNoIGFib3V0IHNwZWNp ZmljIGNoYW5nZXMgdGhhdCBoYXZlIHRvIGJlDQo+ID4gPiBtYWRlIHRvIGhpc3RvcmljIHZlcnNp b25zIG9mIHRoZSByZWdyZXNzaW9uIGRhdGFiYXNlIHRvIGFsbG93IHRoZW0NCj4gPiA+IHRvIGJl IHJlbG9hZGVkIGludG8gY3VycmVudCBzZXJ2ZXJzLiAgQXMgYWxyZWFkeSBkaXNjdXNzZWQsIHRo aXMgaXMNCj4gPiA+IHJlYWxseSBkdXBsaWNhdGl2ZSBvZiBrbm93bGVkZ2UgdGhhdCdzIGJlZW4g ZW1iZWRkZWQgaW50byB0aGUgYnVpbGRmYXJtDQo+ID4gPiBjbGllbnQgb3ZlciB0aW1lLiAgSXQn ZCBiZSBiZXR0ZXIgaWYgd2UgY291bGQgcmVmYWN0b3IgdGhhdCBzbyB0aGF0DQo+ID4gPiB0aGUg YnVpbGRmYXJtIHNoYXJlcyBhIGNvbW1vbiBkYXRhYmFzZSBvZiB0aGVzZSBhY3Rpb25zIHdpdGgg dGVzdC5zaC4NCj4gPiA+IEFuZCBzYWlkIGRhdGFiYXNlIG91Z2h0IHRvIGJlIGluIG91ciBnaXQg dHJlZSwgc28gY29tbWl0dGVycyBjb3VsZA0KPiA+ID4gZml4IHByb2JsZW1zIHdpdGhvdXQgaGF2 aW5nIHRvIGdldCBBbmRyZXcgaW52b2x2ZWQgZXZlcnkgdGltZS4NCj4gPiA+IEkgdGhpbmsgdGhp cyBjb3VsZCBiZSByZXByZXNlbnRlZCBhcyBhIHBzcWwgc2NyaXB0LCBhdCBsZWFzdCBpbg0KPiA+ ID4gdmVyc2lvbnMgdGhhdCBoYXZlIHBzcWwgXGlmIChidXQgdGhhdCBjYW1lIGluIGluIHYxMCwg c28gbWF5YmUNCj4gPiA+IHdlJ3JlIHRoZXJlIGFscmVhZHkpLg0KPiA+IA0KPiA+IEkgc3RhcnRl ZCB0aGlzLiAgSSBkb24ndCBrbm93IGlmIGl0J3MgY29tcGF0aWJsZSB3aXRoIHRoZSBidWlsZGZh cm0gY2xpZW50LCBidXQNCj4gPiBJIHRoaW5rIGFueSBpc3N1ZXMgbWF5YmUgY2FuIGJlIGF2b2lk ZWQgYnkgdXNpbmcgIklGIEVYSVNUUyIuDQo+IA0KPiBJJ20gZ29pbmcgdG8gdHJ5IHB1bGxpbmcg dGhpcyBpbnRvIGEgcHNxbCBzY3JpcHQgdG9kYXkgYW5kIHNlZSBob3cgZmFyDQo+IEkgZ2V0Lg0K DQpJIGNvbXBsZXRlbHkgbWlzcmVhZCB0aGlzIGV4Y2hhbmdlIC0tIHlvdSBhbHJlYWR5IGRpZCB0 aGlzIGluIDAwMDQuDQpTb3JyeSBmb3IgdGhlIG5vaXNlLg0KDQotLUphY29iDQo=