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 1kpgRE-0004iY-IS for pgsql-docs@arkaria.postgresql.org; Wed, 16 Dec 2020 23:42:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kpgRD-0005EG-Fj for pgsql-docs@arkaria.postgresql.org; Wed, 16 Dec 2020 23:42:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kpgRD-0005E9-AI for pgsql-docs@lists.postgresql.org; Wed, 16 Dec 2020 23:42:31 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kpgRA-00043l-Rv for pgsql-docs@lists.postgresql.org; Wed, 16 Dec 2020 23:42:30 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1kpgR9-0005hc-5s; Wed, 16 Dec 2020 18:42:27 -0500 Date: Wed, 16 Dec 2020 18:42:27 -0500 From: Bruce Momjian To: ramkly@yahoo.com, pgsql-docs@lists.postgresql.org Subject: Re: pg_upgrade is not correct Message-ID: <20201216234227.GI4527@momjian.us> References: <160739721042.708.4306720394513934628@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <160739721042.708.4306720394513934628@wrigleys.postgresql.org> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Dec 8, 2020 at 03:13:30AM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/pgupgrade.html > Description: > > If we use the following command to upgrade the standby server, then new > cluster will create by old_cluster which is not correct. > rsync --archive --delete --hard-links --size-only --no-inc-recursive > old_cluster new_cluster remote_dir > I used following command and this one is correct: > rsync --archive --delete --hard-links --size-only --no-inc-recursive > new_cluster old_cluster remote_dir > So the only thing need to change is the place of old_cluster and new_cluster > in rsync command. I am not sure how to reply. These instructions have been unchanged for a few years. Why is the order you suggest correct? -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee