Re: pg_upgrade from V9.3.3 to V9.4.0 - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: pg_upgrade from V9.3.3 to V9.4.0
Date
Msg-id 20150110203246.GA8544@momjian.us
Whole thread Raw
In response to Re: pg_upgrade from V9.3.3 to V9.4.0  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
Responses Re: pg_upgrade from V9.3.3 to V9.4.0
List pgsql-admin
On Sat, Jan 10, 2015 at 07:13:00PM +0530, Harshad Adalkonda wrote:
>
> On Sat, Jan 10, 2015 at 3:57 AM, John Scalia <jayknowsunix@gmail.com> wrote:
>
>     Hi all,
>
>     While we're not planning to migrate to the new version, I'm trying to gain
>     some experience as the streaming replication has really changed in this
>     version and indicates future directions for it. My environment is
>     virtualized CentO/S 6.5, and this particular server is the current primary,
>     not a standby. My problem is that the pg_upgrade is just hanging - for over
>     an hour, before I killed it. I only see a "Verifying Cluster" message, and
>     that's it. Even the 3 logs written by pg_upgrade, don't really tell me any
>     more. Am I trying to go too far with this upgrade? Do I need to bring it
>     V9.3.4 first, or what? The behavior just seems a bit odd. I've only run
>     this prior going from 9.2.2 to 9.3.3 and that had no issues.
>
> Hi John Scalia,
>
> I have tried pg_upgrade from 9.3.3 to 9.4.0 and i have done with the following
> procedure which will solve your problem.
>
> Create .pgpass file in users home directory ~/.pgpass and add both server with
> their respective user & password

Oh, so you are thinking it is waiting for a password?  Wouldn't it say
"Password:"?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-admin by date:

Previous
From: David G Johnston
Date:
Subject: Re: PK/FK impacts using text data type
Next
From: John Scalia
Date:
Subject: Re: pg_upgrade from V9.3.3 to V9.4.0