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 1hTVdl-0006cF-EI for pgsql-hackers@arkaria.postgresql.org; Wed, 22 May 2019 18:07:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hTVdj-0007Ny-2d for pgsql-hackers@arkaria.postgresql.org; Wed, 22 May 2019 18:06:59 +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 1hTVdi-0007Mo-PP for pgsql-hackers@lists.postgresql.org; Wed, 22 May 2019 18:06:58 +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 1hTVdg-0000x5-Ne for pgsql-hackers@postgresql.org; Wed, 22 May 2019 18:06:58 +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 x4MI6lYC007201; Wed, 22 May 2019 14:06:47 -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: <20190522175150.c26f4jkqytahajdg@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> Comments: In-reply-to Andres Freund message dated "Wed, 22 May 2019 10:51:50 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <7199.1558548407.1@sss.pgh.pa.us> Date: Wed, 22 May 2019 14:06:47 -0400 Message-ID: <7200.1558548407@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Andres Freund writes: > Seems what we need to fix the immediate issue is to ressurect: > # We need to make it use psql from our temporary installation, > # because otherwise the installcheck run below would try to > # use psql from the proper installation directory, which might > # be outdated or missing. But don't override anything else that's > # already in EXTRA_REGRESS_OPTS. > EXTRA_REGRESS_OPTS="$EXTRA_REGRESS_OPTS --bindir='$bindir'" > export EXTRA_REGRESS_OPTS > and put that into global scope. 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. (IOW, keep an eye on the cross-version-upgrade tests while you mess with this...) regards, tom lane