Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fSt3y-0002Uv-73 for pgsql-admin@arkaria.postgresql.org; Tue, 12 Jun 2018 23:50:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fSt3w-000701-C6 for pgsql-admin@arkaria.postgresql.org; Tue, 12 Jun 2018 23:50:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fSt3v-0006zi-4w; Tue, 12 Jun 2018 23:50:56 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fSt3m-0004ZX-Oe; Tue, 12 Jun 2018 23:50:54 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 2EA192183D; Tue, 12 Jun 2018 19:50:45 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Tue, 12 Jun 2018 19:50:45 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=fzQ/MOxj8a2HhGc/FcicHCBXA/ffk 0RKgXinlkag/Ms=; b=1Mrs3kK2PQl87bkaBwb9fJEJ7G+0fchAQ9EuK5g9CXXPl EVdvo0l4apUKIsL9rtxer8uslbhpG8ZTmQgdW1IpmLeEoAoe2HbkfODCEUy9xy6o BFCLdHj+AnvgZufuA8qMIkeKHKFqfZ3cC+3Zt00pISpR55EvKqz8jpYPPoR7OfUJ 6HapcTvWBmkhFP0HlLu08E9/xU6rGlTVVDIN5NoPMiM+FawBQXLzsuRgTT79kRFd R6pVTvnwwah+To5QKiOUILaHSJfRme2eJvon5LdCHygu/tHdS1WbJHNOWQakihl9 K1y1Dk2AW82KFULGtZV7stvNBhmdLEM/Ugj5bsyLw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=fzQ/MO xj8a2HhGc/FcicHCBXA/ffk0RKgXinlkag/Ms=; b=GV4E62+Chn2czs4mLRjN1s iCddvANaYXFTztAz8xcugxi1PoQDW0LAvmpLrZdpeaRSLwkDQbTylmEqTephaMwF Yq4483QdQZEdqTFcirNwLFc83FHDSgkY9wGkZJkglxPuhFhcF4ehoCDBwE67av19 b0EErEpGNi/6Hz986Lke8G6n8Fz/eyfTBfPWW0acnAmr0DyHSyhOswPDPFqSh+dI BmtNpiUnWVNxYFFZaqoyzqjV00ynUOka9bbwE3zy/TIs7aJ9XHyf7ei0Uejn9XKd 1ZSON3f2rqMRfcXTBSMUG+qWGUHlkcYrQhbe/4b3bYeRHfoqExFiLAD8u0Z5ZGSA == X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Proxy: X-ME-Sender: Received: from [192.168.1.3] (unknown [71.212.159.209]) by mail.messagingengine.com (Postfix) with ESMTPA id 48FF510261; Tue, 12 Jun 2018 19:50:44 -0400 (EDT) Subject: Re: pg_upgrade 10.2 To: Murthy Nunna , "pgsql-general@lists.postgresql.org" , "pgsql-admin@lists.postgresql.org" , "pgsql-performance@lists.postgresql.org" References: <1a3ebd40-7870-3eab-97d4-ca2b9907d917@aklaver.com> <5f0d7335-e681-56bb-7d14-cf97fccb1bcf@aklaver.com> <4b66fd13-951c-fab6-a618-d27860ba465b@aklaver.com> From: Adrian Klaver Message-ID: <523a2043-c269-4bb0-6859-a73f3fc7ad41@aklaver.com> Date: Tue, 12 Jun 2018 16:50:43 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; 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 06/12/2018 02:49 PM, Murthy Nunna wrote: > Hi Adrian, > > Port numbers are correct. > > I moved the position of -c (-p 5433 -P 5434 -c -r -v). Now it is NOT complaining about old cluster running. However, I am running into a different problem. > > New cluster database "ifb_prd_last" is not empty > Failure, exiting > > Note: ifb_prd_last is not new cluster. It is actually old cluster. > > Is this possibly because in one of my earlier attempts where I shutdown old cluster and ran pg_upgrade with -c at the end of the command line. I think -c was ignored and my cluster has been upgraded in that attempt. Is that possible? I don't so because it exited before it got the upgrading part. -- Adrian Klaver adrian.klaver@aklaver.com