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 1lHNKE-0003b7-Vj for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Mar 2021 08:57:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lHNKD-0008Pa-T9 for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Mar 2021 08:57:45 +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 1lHNKD-0008PT-M6 for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 08:57:45 +0000 Received: from forward1-smtp.messagingengine.com ([66.111.4.223]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHNKB-0007VX-CU for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 08:57:44 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.nyi.internal (Postfix) with ESMTP id EEF821940B52; Wed, 3 Mar 2021 03:57:41 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 03 Mar 2021 03:57:41 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; bh=B0xJWgV8ec+FD/wBt/8iHkFexNkq0rwrZGAKExL3N Hg=; b=ROH+Xdg7fqj3WiYW+3AYcT5LAevjX0II3sVqzeZYDMh+RxO+cjZ4/4Dzn RSGBeONPqogf0B61BxpZTeU5NoHRpUA1MlvCzJkDIx5BHYGe5F9VP3lo/Qiemzgo w02xtuQ38TVJDA0vJnPyhtpyBke/lUuRDFBaAtaWzhwwhs3b3eHLk/gfJLkeflsx 004p/Lo+Uf7KwqTHaTAWdC2MQccCWod76l/qrUdHU1s4V1PaTAzNUmYjBd6St40E +NAAaSp1UBMLB3cWuaby0w4kLmIDFB1Gn305YTNS9VQ399ZXAUV7aQJ7d6VxdZU7 kA7zT/MPHJwSS0BJzWcl6a0pkwVBA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledruddtuddguddukecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefuvfhfhffkffgfgggjtgfgsehtjeertddtfeehnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuggftrfgrthhtvghrnhepfeehleefudevjeeiheek leeuffdujefgffffheeiuddvhfelgeekkeeggfevudeknecukfhppeekjedrudejjedrie elrddugedtnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhho mhepphgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from laptop206oxuk.local (p57b1458c.dip0.t-ipconnect.de [87.177.69.140]) by mail.messagingengine.com (Postfix) with ESMTPA id 2DD7E240064; Wed, 3 Mar 2021 03:57:41 -0500 (EST) Subject: Re: pg_upgrade version checking questions To: Daniel Gustafsson Cc: "pgsql-hackers@lists.postgresql.org" References: <9328.1552952117@sss.pgh.pa.us> <20190327124351.GG12804@msg.df7cb.de> <29b364fe-b1f9-5171-6f78-1f01a94244ac@2ndquadrant.com> <3177834d-8313-c641-2d20-f99d69d8b6ff@2ndquadrant.com> <3CE32AD0-678E-42A8-A2B1-C2A3EDDE15C7@yesql.se> <22906594-DDD7-4085-8318-595C0C9C75C6@yesql.se> From: Peter Eisentraut Message-ID: <35ec2a77-2d38-d65e-fe9f-737a0c0c2955@2ndquadrant.com> Date: Wed, 3 Mar 2021 09:57:38 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.16; rv:78.0) Gecko/20100101 Thunderbird/78.7.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 02.03.21 22:51, Daniel Gustafsson wrote: >> The commit message says something about "to ensure the health of the target cluster", which doesn't make sense to me. Maybe find a better wording. > > Reworded in the attached updated version. > >> The name find_exec() seems not very accurate. It doesn't find anything. Maybe "check"? > > I'm not wild about check_exec(), but every other name I could think of was > drastically worse so I went with check_exec. > >> I'm not sure why the new find_exec() adds EXE. AFAIK, this is only required for stat(), and validate_exec() already does it. > > Good point, fixed. I committed this. I added a pg_strip_crlf() so that there are no newlines in the error message. I also slightly reworded the error message to make the found and expected value distinguishable.