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 1hUJdK-0006h8-KQ for pgsql-hackers@arkaria.postgresql.org; Fri, 24 May 2019 23:29:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hUJdI-0004SG-W5 for pgsql-hackers@arkaria.postgresql.org; Fri, 24 May 2019 23:29:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hUJdI-0004S9-Jt for pgsql-hackers@lists.postgresql.org; Fri, 24 May 2019 23:29:52 +0000 Received: from mail-yw1-xc43.google.com ([2607:f8b0:4864:20::c43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hUJdB-0004cS-GM for pgsql-hackers@postgresql.org; Fri, 24 May 2019 23:29:51 +0000 Received: by mail-yw1-xc43.google.com with SMTP id k70so4152ywe.7 for ; Fri, 24 May 2019 16:29:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=NKpe5s3Om6p9PjU9U07hi1Md39tkqBvgm+QkZRIS/kk=; b=Q2NTO4UuNjQVHa/jC9+q1vh27NGJDcmRgEopA8tAg9Y+ELbzcaJsnxzhJI6wmASoWO nIr8747qCnVaG77teMtttJ/JRFh8chDzoQkXB90yo9h0TmDINEvOgNTq5HM0hhH21MBV g1DBvj2anzZ5j/cX7JYgoYyl9vzMKNIyFXOsoM8BvfnwE1wIQPKMcTTb7+gnZzcNF18D /bjpMP8320rDIcmTy+CUMCxJe3J1WkU1EMWwFc+5CqR4nZ4E/hK6krobgUMZA9+DyHQS 9Adpp5ZhesK7TzxbX8nc1VtjdZB5W0ioh4YQBRMv50GNMEHFyqC3oCsaaEWCUs6Ie5jZ YcDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-transfer-encoding:content-language; bh=NKpe5s3Om6p9PjU9U07hi1Md39tkqBvgm+QkZRIS/kk=; b=M65uaIcYjcwFk5EDQU0HeI+oz9jPnD/CuoPfVxWbTqR3LY/GEyzAJnWJs0x9Ox7fBT 3mAgWbaUv+RLUPpGgQeBptym+B8Y4wMm67RIZXyzAXelxkRSjQXiqoqSCi4yueXeigAb JjmWahW/rs7/8gH273GVhzxnoElIZpiJsbOwTCC/5Ia3Zd62fkymB7p/Cj1AI4XlwBrg SRWR3kMFDSZC/mqb4fUGvnQ2NcmwKsEWhm2vICXUVeKPiYSdaUm2XrFQGGpp2urYyKRj Er/P+06xe5MjIvH+r3hz+CWhIDET5btCzS9oDDddzveR6p4L9oGobHg7GT/wZoNfhw1X nX/g== X-Gm-Message-State: APjAAAUhGt8WYoZ3BSGf7j+OwUArhxJu4tAOgO63tmDHzhHiplsi8cmi KeFxxDF7oekJ84fRNysg7YTqqrQWLWIc5/bFze9QpGzr0qVc9KO9XLv4j0FGYu78PreYE/DcqrQ i4CZZhmOWuRra9ZMEhEjbeQNS6KM2us0p/eXXtStnHSYA/VIirtjIwJKRZaCSP6l7MD4CsKehPC Iyq0o5HvNllgwnNI4= X-Google-Smtp-Source: APXvYqwxSTRrd8KnwZGOi7852Zrx3po5fEt3YgSVIa4rnpGUjVQQlkzeLFch8cyloGAed91IVDCPNw== X-Received: by 2002:a0d:f587:: with SMTP id e129mr445134ywf.465.1558740584364; Fri, 24 May 2019 16:29:44 -0700 (PDT) Received: from [192.168.10.146] (99-10-92-30.lightspeed.rlghnc.sbcglobal.net. [99.10.92.30]) by smtp.gmail.com with ESMTPSA id p83sm1162580ywp.36.2019.05.24.16.29.43 (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Fri, 24 May 2019 16:29:43 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: Teach pg_upgrade test to honor NO_TEMP_INSTALL To: Andres Freund Cc: Tom Lane , Thomas Munro , PostgreSQL-development References: <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> <7965.1558549671@sss.pgh.pa.us> <20190522184254.vi5w4icue7vu4km5@alap3.anarazel.de> <2b42bb13-7a7e-e295-2054-9a209749c3a7@2ndQuadrant.com> <20190522200841.zhn64al5ysfu37kq@alap3.anarazel.de> <20190524152238.khwwyl6wiflbffxw@alap3.anarazel.de> Openpgp: preference=signencrypt Autocrypt: addr=andrew.dunstan@2ndQuadrant.com; prefer-encrypt=mutual; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNL0FuZHJldyBEdW5zdGFuIDxhbmRyZXcuZHVuc3RhbkAybmRRdWFkcmFudC5jb20+wsCY BBMBAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAUJDyV6hBYhBOQ+WEYd/Hy/RGkV pZn6f8tZ/DuBBQJcH/EVAhkBAAoJEJn6f8tZ/DuB7BEH/iDWZEbVft2m2MT6SPjARzTupt/l xLLZ/Cl6n2US2hov5+fBbnR5xvECk/YCOfG9ICvKNlpFjceqNLRKStd8cmndnI+kDw91uNM2 hpL4aJMeW65XCHvqXlOLSwv5chBpXz9NG7FMaJ+q+59sWEWjcTNmjXgkEHn53y+1pc7nSLDe cr5ZI1aB3nGXRm1SoDY5PYZkUKMykW+YBZwgcs/Q5tRaE+siN7DKbz8E628+PerwAkmHPVXN MdJFD6gs4S0gDFA8IxcyIwZU2v4By+brzcJ9Se3FK5BYxBDHtaYZxgSrJAvOUOrLIZPQTQfL TtnVs3C3JTfrxCH1ceHtnA6dRuTOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oK Waqf+wmW4tpDe/VVcxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7 llV0xSSoFiieQBsrGvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8 BoVrRFcdzlIY/NFNhFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C 4R+M6w7o2PLGOjdZ+kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaY L++LAEOqrlvm2TvqQqZRtnEAEQEAAcLAZQQYAQIADwIbDAUCXA6fpAUJDyV6xAAKCRCZ+n/L Wfw7geU4B/9vFFsVmWxerDWgNjyiK80zIPmlw/iwdUlU6FIu0JWLMg4093kvxBs7RMZV9hBq n3ekBvD4IvFsVLJrw9qzSI2FH3UeYy5WXpEs01Ppia60NOlvRDqXbryzuvfe+iYo6bVP3Ikr TPTNYL/BePUTD2DPvSI82SbGTyzuA7SJv6NRqqQDMIy1fU6KyQFLmQJp/QJyhKWzm9jWh8ee w8jVaoMY0Kbq5N7RqisEx1Lu/Iw646UphdYzQNymf+kbiU5Kf4I6DhzV8w9sie1Bo1juNj3I c5/fFJsmxljbnaDbXPcnFsur1Oo9mIHFakgWgOBMuxoWfjONiLjjLh/9+ZIqSSLX Message-ID: <59d22ac1-2ae6-cbf6-519c-aa2ff14fd72a@2ndQuadrant.com> Date: Fri, 24 May 2019 19:29:42 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <20190524152238.khwwyl6wiflbffxw@alap3.anarazel.de> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 5/24/19 11:22 AM, Andres Freund wrote: > Hi, > > On 2019-05-22 13:08:41 -0700, Andres Freund wrote: >> On 2019-05-22 16:04:34 -0400, Andrew Dunstan wrote: >>> If I disable install, the buildfarm fails the upgrade check even when >>> not using NO_TEMP_INSTALL. >>> >>> >>> excerpts from the log: >>> sh: /home/pgl/npgl/pg_head/bfroot/HEAD/inst/bin/psql: No such file or >>> directory >> That's the issue I was talking to Tom about above. Need to >> unconditionally have >> .... > Andrew, after the latest set of changes, the reversed order should now > work reliably? > With the latest changes I don't get the above failure: andrew@emma:pg_head (master)$ ~/bf/client-code/run_build.pl  --skip-steps=install master:HEAD          [19:21:45] creating vpath build dir /home/pgl/npgl/pg_head/bfroot/HEAD/pgsql.build ... master:HEAD          [19:21:45] running configure ... master:HEAD          [19:21:52] running make ... master:HEAD          [19:23:42] running make check ... master:HEAD          [19:24:37] running make contrib ... master:HEAD          [19:24:45] running make testmodules ... master:HEAD          [19:24:45] checking pg_upgrade master:HEAD          [19:26:41] checking test-decoding master:HEAD          [19:26:59] running make ecpg check ... master:HEAD          [19:27:25] OK cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services