Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YE8is-0008Ex-J3 for pgsql-admin@arkaria.postgresql.org; Thu, 22 Jan 2015 03:46:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YE8is-0000du-41 for pgsql-admin@arkaria.postgresql.org; Thu, 22 Jan 2015 03:46:22 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YE8ir-0000dj-B7 for pgsql-admin@postgresql.org; Thu, 22 Jan 2015 03:46:21 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YE8io-0001mc-5D for pgsql-admin@postgresql.org; Thu, 22 Jan 2015 03:46:19 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1YE8in-000731-0V; Wed, 21 Jan 2015 22:46:17 -0500 Date: Wed, 21 Jan 2015 22:46:17 -0500 From: Bruce Momjian To: John Scalia Cc: "pgsql-admin@postgresql.org" Subject: Re: Back to my pg_upgrade stoppage problem Message-ID: <20150122034617.GB19475@momjian.us> References: <54B934A3.9020604@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <54B934A3.9020604@gmail.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Fri, Jan 16, 2015 at 10:56:19AM -0500, John Scalia wrote: > Hi all, > > I'm back to trying to figure out the pg_upgrade stoppage problem on > my V9.4.0 upgrade from V9.3.3. As stated earlier, my environment is > CentOS 6.5 kernel and the server is virtualized, but has been > running 9.3.3 for some time now. I ran pg_upgrade on this system as > follows, I apologize for the length of the message but I putting the > entire screen capture into this. You can see at the end that it got > hung up trying to create a temporary table, but the server has been > on this step for nearly an hour now. It had successfully performed > several queries prior to this, and those were successful. I suggest you upgrade to V9.3.5 at a minimum. Second, try the why on its own to see if it works. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin