Re: Back to my pg_upgrade stoppage problem - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Back to my pg_upgrade stoppage problem
Date
Msg-id 20150122034617.GB19475@momjian.us
Whole thread Raw
In response to Back to my pg_upgrade stoppage problem  (John Scalia <jayknowsunix@gmail.com>)
Responses Re: Back to my pg_upgrade stoppage problem
List pgsql-admin
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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-admin by date:

Previous
From: Craig James
Date:
Subject: Re: pg_basebackup bug: base backup is double the size of the database
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL 9.3 synchronous replication