Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hTVy6-0007V1-GE for pgsql-hackers@arkaria.postgresql.org; Wed, 22 May 2019 18:28:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hTVy4-0003GO-Sv for pgsql-hackers@arkaria.postgresql.org; Wed, 22 May 2019 18:28:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hTVy4-0003Fn-KP for pgsql-hackers@lists.postgresql.org; Wed, 22 May 2019 18:28:00 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hTVy2-0001Q0-HX for pgsql-hackers@postgresql.org; Wed, 22 May 2019 18:28:00 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x4MIRpoQ007966; Wed, 22 May 2019 14:27:51 -0400 From: Tom Lane To: Andres Freund cc: Thomas Munro , Andrew Dunstan , PostgreSQL-development Subject: Re: Teach pg_upgrade test to honor NO_TEMP_INSTALL In-reply-to: <20190522182027.fzytm3tciqefgz43@alap3.anarazel.de> References: <5506b8fa-7dad-8483-053c-7ca7ef04f01a@2ndQuadrant.com> <20190521015840.cztw2qxthh7xuutk@alap3.anarazel.de> <20190521191918.z7kwnrlj45mk2k67@alap3.anarazel.de> <20190521194129.2kl2mldesrr65gmb@alap3.anarazel.de> <7333.1558537134@sss.pgh.pa.us> <20190522175150.c26f4jkqytahajdg@alap3.anarazel.de> <7200.1558548407@sss.pgh.pa.us> <20190522182027.fzytm3tciqefgz43@alap3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Wed, 22 May 2019 11:20:27 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <7964.1558549671.1@sss.pgh.pa.us> Date: Wed, 22 May 2019 14:27:51 -0400 Message-ID: <7965.1558549671@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Andres Freund writes: > On 2019-05-22 14:06:47 -0400, Tom Lane wrote: >> Not sure about that last bit. pg_upgrade has the issue of possibly >> wanting to deal with 2 installations, unlike the rest of the tree, >> so I'm not sure that fixing its problem means there's something we >> need to change everywhere else. > I'm not quite following? We need to move it into global scope to fix the > issue at hand (namely that we currently need to make install first, just > to get psql). And at which scope could it be in master, other than > global? Maybe I misunderstood you --- I thought you were talking about something like defining EXTRA_REGRESS_OPTS in Makefile.global. If you mean running this unconditionally within test.sh, I've got no objection to that. > I do think we will have to move it to the global scope in the back > branches too, because NO_TEMP_INSTALL does indeed fail without a global > install first (rather than using the temp install, as intended): Agreed, we should fix it in all branches, because it seems like it's probably testing the wrong thing, ie using the later branch's psql to run the earlier branch's regression tests. regards, tom lane