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@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 & passwordOh, 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
