Message-ID: <54B1CA0A.1020007@gmail.com>
Date: Sat, 10 Jan 2015 19:55:38 -0500
From: John Scalia <jayknowsunix@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.3.0
MIME-Version: 1.0
To: Bruce Momjian <bruce@momjian.us>,
 Harshad Adalkonda <adalkondaharshad@gmail.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: pg_upgrade from V9.3.3 to V9.4.0
References: <54B055C3.5070003@gmail.com>
 <CANnQH_gpdfb4gt+76gffvHYSon+UrQYCLaD89UP24zvigpU_SQ@mail.gmail.com>
 <20150110203246.GA8544@momjian.us>
In-Reply-To: <20150110203246.GA8544@momjian.us>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


On 1/10/2015 3:32 PM, Bruce Momjian wrote:
> 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:"?
>
I saw nothing on the terminal, nor anything in the logfiles indicating a password request.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin