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 1m4SAQ-0007y2-0x for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 18:02:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4SAP-0006Ah-0x for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jul 2021 18:02:29 +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 1m4SAO-0006AZ-GG for pgsql-hackers@lists.postgresql.org; Fri, 16 Jul 2021 18:02:28 +0000 Received: from mail-bn1nam07on2071.outbound.protection.outlook.com ([40.107.212.71] helo=NAM02-BN1-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 1m4SAL-0002Ox-0R for pgsql-hackers@lists.postgresql.org; Fri, 16 Jul 2021 18:02:28 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=f1Twjr0GesMvUOSL3gueCC+kyUngNg4oKl2FndS7I64ztx9YynScit6EkFaH7W2fE+YYKsImUnZQVVAY764nxQ6ZF7j0f/qSM2ODzsvoOSq/mk3CTU6nbRvpzkeSHlWQM/qgL3VEOxG2zQWcZyN4RCfSEGA234qgtELi1RjdQzzIfxPBIvtsPO1CXANKhXcLjd0xUxLkvFjP30TwwxOP0Del6q/waOiLRV5GlUdA5biPzGG44cpbNkNdk3o7qXSrfJKRxc7FeC6qNCt6f0nR0QseVDMfECuTTPM4iQS0y2Q19XXpefNm4LW4nrAm4ej/Z9wvwveVzwljisJKcBJf3A== 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=yoVN4MCd8/GDUFFxo3StTBbeotXT8DXalscH0yKdKJk=; b=Sy3FgYOAIVSM+Mq8QIRpmQhHAgUF8PXbC/xQ813Q+HZ4ugKe0AIJqrQ+ZqbA+5FH+P5CaxMGbq/GLxjTW+llR/xFvPc4Ym+gg5xhMTzfqIApjnsPfIrFs4vzovYbp3TJ7WMkhEMKOkqA7NgiAYUdzuQu02UXhttChxaWO3xHfAFWibUfCcMKP/dITpVaPFwgP63b2K/oNBlvAsWgH+Dn/PUwi6sslYLc5Eo9lHpn1N5P+e4NiuSVW1TPQqeh6dx+azUyK1N3L6cU/zhok7wKZTIXMU+FXVFLrIoSRgCp7PVRwWWxyCy8uus3SlDpeXty1uTUkCo/gEAcm47SY+MdWA== 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=yoVN4MCd8/GDUFFxo3StTBbeotXT8DXalscH0yKdKJk=; b=QDvRO6KZNWFliCPdtakS0g6eQVORL12PZavMqEKzz4+SUE4jF3nTmELN03u0ss+PvVghwzNttg1REAakyxzHnFy3XWXKk/gcvzv2EIuDU/fXB2LCQrOEgtPmFKuAXiQYQfCBSoSlCe5atxZNiKZFaEYL+PS/lxu0zTHy8c3uSfU= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by CO2PR05MB2504.namprd05.prod.outlook.com (2603:10b6:102:10::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4352.9; Fri, 16 Jul 2021 18:02:19 +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 18:02:19 +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/oTTr5TiqKsCkO4HbbPWLsyjqn6CBSAgBFnAoCAF0TsAIAA5rUAgADahYCAAANTgIAAB0gAgABAaQCAA9DJgIBPXhGAgFZXqQCAePq3AA== Date: Fri, 16 Jul 2021 18:02:18 +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: eed2445c-2796-4358-e984-08d94883da5a x-ms-traffictypediagnostic: CO2PR05MB2504: 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: ftVFzB2V5Jw9phK+M/trgyIFbJW5ZOUIjSwMYCULUqHQoEj8lZdBPXxKo8AaI5b3cUOYIChxKq8gUMe52mpSawPEZZLbypSEXJYJXXiLRsjfFGW/ZKyQzFqjwgyXjrW+MNoCbFEn8Fm7T3AEtu0wLUUqUeFyNX4h0mFe+RORGTSJmpnGm/d/UgB6GYXyRgLR5QBYjoxMILeBgvY1N0RPD40/RkeP/nzLFSih4wVR0B4DFz8Ol5AXOFNzihoUxJoiQVzs9kF1WxAPRKTxGvhbNMNJXabR4cJzyTNVDYkDCctvLvldx9dYi6xCSCSnudQ34tLYBxPdK56mW4WXDxpnJanNVqQ420KNubTGZdeS5U78p17eZUStUTaff7EV/SXgGQOpK0dzIlNVJBViI/3NEMBPWIIhOV5FbWVdFDro781xEYXrqk47XDo9u+71PlsO1dEEU8ix2u1b5+hURMeSwh5F8XIIYIK2IesktdREb7BDwuva32hEciijEnRbkrZE5cY8vxipTpZC/+LczbRtU7zdXEn+L15hAJkGUga+2l4oSMQNikKxCWTTE4sHjMUBgmSkIloSi7F8OY7jjz4qm/WA8vxhMH5VOK/EN+aQjKuT2W27k+9K5bp9V8PkiPnp1wWlOGaCc9cZzM8JHMYhtTAez1IYZpOVUTaDKnKnmpP/S2I5/upq7W/Uv7K+31gHvfIjrzXK6qqeujD4fZt9450utd6aUw8KIf0sVouIX9YqBo76p3VTTI5m1GredfsrtLkkzgzZg1qjA1cmLdbvaqO07TqUW/yHdoHVPdCCqZk= 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)(6512007)(966005)(2906002)(6506007)(66946007)(66446008)(64756008)(76116006)(66556008)(66476007)(8936002)(186003)(4326008)(7416002)(8676002)(36756003)(86362001)(2616005)(26005)(71200400001)(83380400001)(5660300002)(316002)(54906003)(508600001)(6486002)(38100700002)(122000001)(110136005)(38070700004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?U1o5WndtVlMzQXdxZi9wazg2WTN4QWdZMkpibDZjRXVFaVN5Rnp5R0R4USsy?= =?utf-8?B?ZnZUditwcG54NW9XaTl6c1RtbXk0djNMeWJzdGhFcHJwOEsxY25US3RnTEc5?= =?utf-8?B?Mzd6dXlOZHQ4MHdLc3RyM09sNUdzNHhXazJUTXhQWWIwb2VBT01GTXN5T0tR?= =?utf-8?B?VitBTTZYSkdINXR2SDFVMVlKRGhIVEYzY2QxaUJwYkxKTDNUNGRnQXVHdWVO?= =?utf-8?B?Z1l2NFlvdkQvNFpYUjBHd2hvdnZseDg2T04yMnNhQ2JEa3VHN0Y2QXBUWlBH?= =?utf-8?B?eFFYZGMrbVZIL0k0TEQvTTF6aG1iRnFCSWhOK09MNVppTWpRakMxdXl4dTJ0?= =?utf-8?B?OW52T2E1N3NnZFQ1dHduMFJ3M3dIWThtdXMzSVlxNFprSG1jM1JPQ0tINTlq?= =?utf-8?B?NjJQNC9pWUkvRzdVcU9xTzNPd3BGSmowWFZNMXlJQjJjazBqSnVUdGNrZEZP?= =?utf-8?B?VVkvbE1RTEgrVURPamVVcTJHVjlaYmxBOEVTd0V5alNadVFTV0NXT0RaYi9P?= =?utf-8?B?UEppNTZiTDQ4TzFiOVBLWFVMU2hxWUhraXBtMHc1QWs2VE5PRnJ0aVdmVVIz?= =?utf-8?B?ck9PRDAxL3FhWGoyQ1BMMy9CNWs5RWViSE42cktSYjhLTmgxdXZuTXR6UlMy?= =?utf-8?B?c0E3bWlKOGsrWWhrSWVSa3k1TDJNVU1oUVg3ZzJmaFBlN3o2TVJBYmh5OWk3?= =?utf-8?B?NEhNMDVRQStzbGNkVEVVMFFLalEwOVpNSDRORllSZW5QNzBQR2kzb2FRS2Nl?= =?utf-8?B?T0U3TFlzMzFzTjJKZFFZc0pzMjQyTUFpbXIzWjZWVklGcHNobXYxNXJHSTVa?= =?utf-8?B?WmtmRmpBbTJjeCthQnhjeEdDaysrb2JMZHhSSE0yVVN6YU1EeWZkMmVVZ2RU?= =?utf-8?B?V2kxRk80ZCt2b2JOVDNVKzVrUURWSW1rWjBiaEF1eDkwQnk3QmE2OVBYRjgr?= =?utf-8?B?Q3YzbW9USHNGT2ZSNDBQaXlWNEFkazd6NUxxL09UTXIvbWYxdUFDUXZxQllu?= =?utf-8?B?R1FUcHc5YUJBQ0pIR1R0WnpVVTJHRmFXZkRLOFBYLzZXNERxenY4SXlsMjlR?= =?utf-8?B?WFZpZ0ppcFFSc0toL2FQWVZkL3NTSTZONHhwZ2luVHNlNFJGbzUyaHN0Tm4r?= =?utf-8?B?MGFrTHJUOER6ZWk4S3hQVDVPM0RqSGc2YzJiN0w4QWU0Y1RwVFBHWXhLcGJn?= =?utf-8?B?bEx1WnRsVHFzWmhzcmFRT29JNVY3c0o3WVdHRDd3bjlPdGFBQmg0SUY3Tnhv?= =?utf-8?B?REdYd3RUaWFlcVNKbmVLQnlDYXNOV0RvcWs5aWMrVWhhV0FlT3pmZytVbXpW?= =?utf-8?B?c3NlanI1RU55enh6U3NPQnhNdlhBRW5WZVNzZjZrd0VOdEtFd28yeGNqWjhQ?= =?utf-8?B?UFFkU2p5Z2dKRTlwRXZtblNYQlZ2QmtKSzZWSldRZWtSTkFjcmhXUEhpZDBk?= =?utf-8?B?RlNiWldjQUk4Y2lWUU5WVjZpaHNnSkF3Y1dPc0NUa2JiT2VzNmdMM0JWNlQ1?= =?utf-8?B?MXhJdkdrQkhPSnFCUHZzdXRQS3JvY3Nwc0N0cnNyeW5jTzFMMDR6SEIzQ3ZO?= =?utf-8?B?N0NINHpEWFR1eFF6MkVucisvV2cvL1BldTlCZWw3d0V6RzhWTzBza0d3RWlZ?= =?utf-8?B?bUhiRlJQR2Q3YTVRYitzN0RTUWNoWmRmZlpnaUVWRnJrVGRpU0NKSHZyYzE3?= =?utf-8?B?aFdmaXdIbVZSS1ltWFFpUEx0c2wvMmZzUzd1aVZQSXMyMGtuOGY4MHp0eEhu?= =?utf-8?Q?oLaIGJqKzlgEoaRDZf4IQY/VFWfYMtXXW4v1jn3?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: <6126B9F212D5F641B4C38B7A08C108DD@namprd05.prod.outlook.com> 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: eed2445c-2796-4358-e984-08d94883da5a X-MS-Exchange-CrossTenant-originalarrivaltime: 16 Jul 2021 18:02:18.9933 (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: 5WAFu63u4DAdad4sNrvshT5rqxmh+LCYfnbIY5tduI1gQdUnt2McDbs4f//8rnZiWPg/GWjFfacFLIFXMIqkeQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO2PR05MB2504 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 c3N1ZXMgbWF5YmUgY2FuIGJlIGF2b2lkZWQgYnkgdXNpbmcgIklGIEVYSVNUUyIuDQoNCkhlcmUg YXJlIHRoZSBkaWZmZXJlbmNlcyBJIHNlZSBvbiBhIGZpcnN0IHBhc3MgKHdpdGhvdXQgcHV0dGlu ZyB0b28NCm11Y2ggdGhvdWdodCBpbnRvIGhvdyBzaWduaWZpY2FudCB0aGUgZGlmZmVyZW5jZXMg YXJlKS4gQnVpbGRmYXJtIGNvZGUNCkknbSBjb21wYXJpbmcgYWdhaW5zdCBpcyBhdCBbMV0uDQoN Ci0gQm90aCB2ZXJzaW9ucyBkcm9wIEAjQCBhbmQgYXJyYXlfY2F0X2FjY3VtLCBidXQgdGhlIGJ1 aWxkZmFybQ0KYWRkaXRpb25hbGx5IHJlcGxhY2VzIHRoZW0gd2l0aCBhIG5ldyBvcGVyYXRvciBh bmQgYWdncmVnYXRlLA0KcmVzcGVjdGl2ZWx5Lg0KDQotIFRoZSBidWlsZGZhcm0ncyBkcm9wcGlu ZyBvZiB0YWJsZSBPSURzIGlzIHByb2JhYmx5IG1vcmUgcmVzaWxpZW50LA0Kc2luY2UgaXQgbG9v cHMgb3ZlciBwZ19jbGFzcyBsb29raW5nIGZvciByZWxoYXNvaWRzLg0KDQotIFRoZSBidWlsZGZh cm0gaGFuZGxlcyAob3IgZHJvcHMpIHNldmVyYWwgY29udHJpYiBkYXRhYmFzZXMgaW4NCmFkZGl0 aW9uIHRvIHRoZSBjb3JlIHJlZ3Jlc3Npb24gREIuDQoNCi0gVGhlIHBzcWwgc2NyaXB0IGRyb3Bz IHRoZSBmaXJzdF9lbF9hZ2dfYW55IGFnZ3JlZ2F0ZSBhbmQgYSBgVFJBTlNGT1JNDQpGT1IgaW50 ZWdlcmA7IEkgZG9uJ3Qgc2VlIGFueSBjb3JyZXNwb25kaW5nIGNvZGUgaW4gdGhlIGJ1aWxkZmFy bS4NCg0KLSBTb21lIHZlcnNpb24gcmFuZ2VzIGFyZSBkaWZmZXJlbnQgYmV0d2VlbiB0aGUgdHdv LiBGb3IgZXhhbXBsZSwNCmFic3RpbWVfL3JlbHRpbWVfL3RpbnRlcnZhbF90YmwgYXJlIGRyb3Bw ZWQgYnkgdGhlIGJ1aWxkZmFybSBpZiB0aGUgb2xkDQp2ZXJzaW9uIGlzIDwgOS4zLCB3aGlsZSB0 aGUgcHNxbCBzY3JpcHQgZHJvcHMgdGhlbSBmb3Igb2xkIHZlcnNpb25zIDw9DQoxMC4NCg0KLSBU aGUgYnVpbGRmYXJtIGRyb3BzIHRoZSBwdWJsaWMuPT4gb3BlcmF0b3IgZm9yIG11Y2ggb2xkZXIg dmVyc2lvbnMgb2YNClBvc3RncmVzLiBJIGFzc3VtZSB3ZSBkb24ndCBuZWVkIHRoYXQgaGVyZS4N Cg0KLSBUaGUgYnVpbGRmYXJtIGFkanVzdHMgcGdfcHJvYyBmb3IgdGhlIGxvY2F0aW9uIG9mIHJl Z3Jlc3Muc287IEkgc2VlDQp0aGVyZSdzIGEgY29tbWVudGVkIHBsYWNlaG9sZGVyIGZvciB0aGlz IGF0IHRoZSBlbmQgb2YgdGhlIHBzcWwgc2NyaXB0DQpidXQgaXQncyBub3QgeWV0IGltcGxlbWVu dGVkLg0KDQpBcyBhbiBhc2lkZSwgSSB0aGluayB0aGUgImZyb212MTAiIG5hbWluZyBzY2hlbWUg Zm9yIHRoZSAib2xkIHZlcnNpb24NCjw9IDEwIiBjb25kaXRpb24gaXMgdW5pbnR1aXRpdmUuIElm IHRoZSBvbGQgdmVyc2lvbiBpcyBlLmcuIDkuNiwgd2UncmUNCm5vdCB1cGdyYWRpbmcgImZyb20g MTAiLg0KDQotLUphY29iDQoNClsxXSBodHRwczovL2dpdGh1Yi5jb20vUEdCdWlsZEZhcm0vY2xp ZW50LWNvZGUvYmxvYi9tYWluL1BHQnVpbGQvTW9kdWxlcy9UZXN0VXBncmFkZVh2ZXJzaW9uLnBt DQo=