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 1kzNrq-0002FR-T0 for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Jan 2021 17:54:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kzNrp-0005uv-Qj for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Jan 2021 17:54:05 +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 1kzNrp-0005ul-Jx for pgsql-hackers@lists.postgresql.org; Tue, 12 Jan 2021 17:54:05 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kzNrn-00022A-Bh for pgsql-hackers@lists.postgresql.org; Tue, 12 Jan 2021 17:54:04 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1kzNrg-0000dq-MG; Tue, 12 Jan 2021 12:53:56 -0500 Date: Tue, 12 Jan 2021 12:53:56 -0500 From: Bruce Momjian To: Justin Pryzby Cc: Peter Eisentraut , Tomas Vondra , Tom Lane , Andres Freund , buschmann@nidsa.net, pgsql-hackers@lists.postgresql.org, Noah Misch Subject: Re: pg_upgrade test for binary compatibility of core data types Message-ID: <20210112175356.GP4320@momjian.us> References: <20191015001817.zei45apgpu5dzngr@development> <20191015044118.GO3599@telsasoft.com> <20191015070725.csmdmdvrlb6klwkg@development> <20201206180248.GI24052@telsasoft.com> <20201216172222.GS30237@telsasoft.com> <20201227190729.GB26311@telsasoft.com> <20210112041352.GY1849@telsasoft.com> <20210112171559.GO4320@momjian.us> <20210112172753.GC1849@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210112172753.GC1849@telsasoft.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Jan 12, 2021 at 11:27:53AM -0600, Justin Pryzby wrote: > On Tue, Jan 12, 2021 at 12:15:59PM -0500, Bruce Momjian wrote: > > Uh, what exactly is missing from the beta checklist? I read the patch > > and commit message but don't understand it. > > Did you try to use test.sh to upgrade from a prior release ? > > Evidently it's frequently forgotten, as evidenced by all the "deferred > maintenance" I had to do to allow testing the main patch (currently 0003). > > See also: > > commit 5bab1985dfc25eecf4b098145789955c0b246160 > Author: Tom Lane > Date: Thu Jun 8 13:48:27 2017 -0400 > > Fix bit-rot in pg_upgrade's test.sh, and improve documentation. > > Doing a cross-version upgrade test with test.sh evidently hasn't been > tested since circa 9.2, because the script lacked case branches for > old-version servers newer than 9.1. Future-proof that a bit, and > clean up breakage induced by our recent drop of V0 function call > protocol (namely that oldstyle_length() isn't in the regression > suite anymore). Oh, that is odd. I thought that was regularly run. I have my own test infrastructure that I run for every major release so I never have run the built-in one, except for make check-world. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee