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@xxxxxxxxx> 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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin