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 1kTCmY-0005hd-R8 for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Oct 2020 23:35:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kTCmU-0003sE-ST for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Oct 2020 23:35:34 +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 1kTCmU-0003s1-LB for pgsql-hackers@lists.postgresql.org; Thu, 15 Oct 2020 23:35:34 +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 1kTCmS-0000SQ-6x for pgsql-hackers@postgresql.org; Thu, 15 Oct 2020 23:35:34 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1kTCmQ-0006xk-8O; Thu, 15 Oct 2020 19:35:30 -0400 Date: Thu, 15 Oct 2020 19:35:30 -0400 From: Bruce Momjian To: Justin Pryzby Cc: pgsql-hackers@postgresql.org, Tom Lane Subject: Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Message-ID: <20201015233530.GG3797@momjian.us> References: <20200925005531.GJ23631@telsasoft.com> <20201009185325.GA24870@momjian.us> <20201009192310.GS17626@telsasoft.com> <20201009234251.GA8419@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20201009234251.GA8419@momjian.us> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Oct 9, 2020 at 07:42:51PM -0400, Bruce Momjian wrote: > On Fri, Oct 9, 2020 at 02:23:10PM -0500, Justin Pryzby wrote: > > In my local branch, I had revised this comment to say: > > > > + * Note, v8.4 has no tablespace_suffix, which is fine so long as the version we > > + * being upgraded *to* has a suffix, since it's not allowed to pg_upgrade from > > + * a version to the same version if tablespaces are in use. > > OK, updated patch attached. Also, from your original patch, I didn't > need to call canonicalize_path() since we are not comparing paths, and I > didn't need to include common/relpath.h. I also renamed a variable. Patch applied to all supported versions. Thanks for the report, and the patch. While I listed you as reporter, I forgot to list you as the patch author --- Tom, can you remember that for the minor release notes please? Thanks -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee