pg_upgrade hangs - Mailing list pgsql-admin

From John Scalia
Subject pg_upgrade hangs
Date
Msg-id 53EBE4B6.5030904@gmail.com
Whole thread Raw
Responses Re: pg_upgrade hangs  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Hi all,

My QA folks are doing an upgrade test, migrating a database from 9.2.2 to 9.3.3. By default on CentOS, the databases
liveat: 

/var/lib/pgsql/9.2/data & /var/lib/pgsql/9.3/data

But, they've decided to move these to /data/postgres-9.2/data and /data/postgres-9.3/data and use symlinks back to the
originallocations, so they don't have to modify the  
/etc/init.d scripts. Now, pg_upgrade is just hangs regardless of whether I use the actual physical locations or the
symlinkedones. I haven't yet tried attaching "strace" to the  
process, but is there any reason to believe that the symlinks might be causing the problem? Or do I need to look at
somethingelse? 
--
Jay


pgsql-admin by date:

Previous
From: Mike Sullivan
Date:
Subject: Looking for PostgreSQL reporting tool
Next
From: Fernando Hevia
Date:
Subject: Re: Looking for PostgreSQL reporting tool