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 1n2W4D-0006RL-IW for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Dec 2021 10:20:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n2W4B-0003NB-B7 for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Dec 2021 10:20:19 +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 1n2W4B-0003N2-2M for pgsql-bugs@lists.postgresql.org; Wed, 29 Dec 2021 10:20:19 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n2W43-0007b4-Je for pgsql-bugs@lists.postgresql.org; Wed, 29 Dec 2021 10:20:17 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 895CB3200A2E; Wed, 29 Dec 2021 05:20:09 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Wed, 29 Dec 2021 05:20:09 -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=fm1; bh=ymCpqhNnWyVs3E7JqTWIgeIGvo18a0ysWlr6DK2d2 wY=; b=ibKCkisFmwDfpWUwOafvl89zYnaic7P94jMKUdAM/H9AJevK5y+hGMYjZ jkWRXPdwXXOeTzdo8A5+qdIv07bAIM7t8obGRBgio6xKk3KVZ+PaaxruxdA261Ks GIkQ7/mth0ANdij89XbRdGj9NU/oDUKDKhNUDRupwjUaoW+cE1v6+CEqIhege3mQ yQCQ8DpDacmVNq0TNYnnRFcJDDPIr9lYORPKtu61+TMxm7tD0CkzOEyk1KtMp3Z7 FaVYJ9qpZHsukyRtSVnQbm3XaD8t7Ed2xYar1N6CJVLew5eQ9OIYP7CEW/aagDGs Z3fpThpMXeFtZy6YR/AOrmEbEgPzA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddruddvuddgudeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthekredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvg hrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvghrnhepffeigeetvdeitdejteeu feethfelffetleefieeugfefieetudfhhffhkeduueffnecuffhomhgrihhnpehpohhsth hgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpehpvghtvghrrdgvihhsvghnthhrrghuthesvghnthgvrhhprhhishgvug gsrdgtohhm X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 29 Dec 2021 05:20:07 -0500 (EST) Message-ID: <608adaf4-7637-9a34-95d5-0ca948437f5d@enterprisedb.com> Date: Wed, 29 Dec 2021 11:20:06 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.4.0 Subject: Re: BUG #17347: pg_upgrade: analyze_new_cluster script analyzes wrong cluster Content-Language: en-US To: Mathias Kunter , Tom Lane Cc: pgsql-bugs@lists.postgresql.org References: <17347-27b988f51d9dee1a@postgresql.org> <1760674.1640707235@sss.pgh.pa.us> <10f71bb9-2ca6-24c4-0feb-f64138a0e4b3@gmail.com> From: Peter Eisentraut In-Reply-To: <10f71bb9-2ca6-24c4-0feb-f64138a0e4b3@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 28.12.21 19:12, Mathias Kunter wrote: >> It's a bit moot now anyway, since pg_upgrade doesn't create >> that script anymore in v14 and up. > > The docs at https://www.postgresql.org/docs/14/pgupgrade.html (step 15 > "Statistics") though say the user must "run a command to regenerate that > information".  Is the documentation up-to-date? It actually says "you will be instructed to run a command [...]", which is what happens: It prints out a command that you can use. It also says "You might need to set connection parameters to match your new cluster.", which could apply to your situation.