> > > Postgres is going to /usr/local/pgsql/data/drupal_dbspace/ to look for > the 9.0 files instead of /usr/local/pgsql_90/data/drupal_dbspace/ and is > trying to copy them as 9.3 versions into the new default location which has > the same path. Since the new > /usr/local/pgsql/data/drupal_dbspace/PG_9.0_201008051 > is empty it is failing. >
That is exactly what is going on. I think what I am going to end up doing is: - Leaving 9.0 in the default location, this way it will successfully complete PG upgrade. - Uninstall 9.0 - Manually move the user created tablespaces into the 9.3 data folder - Reinstall 9.3 to go into the default location, right now its installed in /opt using the PREFIX - Move the 9.3 data folder into the default location. - Cleanup the old 9.0 folders Then in theory it should start right up. I would assume that if the user created tablespaces were created outside of the /data folder then this would not be an issue. But again, I am not the DBA, I clean up after everybody else. Thanks for all your help Adrian. -Joseph
