From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Harshad Adalkonda <adalkondaharshad(at)gmail(dot)com> |
Cc: | John Scalia <jayknowsunix(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade from V9.3.3 to V9.4.0 |
Date: | 2015-01-10 20:32:46 |
Message-ID: | 20150110203246.GA8544@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
From | Date | Subject | |
---|---|---|---|
Next Message | John Scalia | 2015-01-11 00:55:38 | Re: pg_upgrade from V9.3.3 to V9.4.0 |
Previous Message | David G Johnston | 2015-01-10 19:25:48 | Re: PK/FK impacts using text data type |