On Wed, Aug 13, 2014 at 06:20:38PM -0400, John Scalia wrote: > 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 live at: > > /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 original > locations, 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 symlinked ones. 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 something else? I have no idea. I have never heard of that, but I suggest you figure out why the hang is happening independent of pg_upgrade. -- 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