Tory M Blue wrote: > On Sat, Dec 3, 2011 at 6:04 AM, Bruce Momjian <bruce@xxxxxxxxxx> wrote: > > > Well, I am not totally clear how you are moving things around, but I do > > know pg_upgrade isn't happy to have the old and new cluster be very > > different. > > > > What I think is happening is that you didn't properly move the > > tablespace in the old cluster. ?We don't give you a very easy way to do > > that. ?You need to not only move the directory, but you need to update > > the symlinks in data/pg_tblspc/, and update the pg_tablespace system > > table. ?Did you do all of that? ?Does the 8.4 server see the tablespace > > properly after the move, but before pg_upgrade? > > > Simple answer is umm no.. The "no" is an answer to which question? > "http://www.postgresql.org/docs/current/static/pgupgrade.html"; is > obviously lacking than :) > > Soooo I can take what you have told me and see if I can't attempt to > make those things happen and try again. Makes sense, but boy that's a > large piece of info missing in the document! You mean moving tablespaces? That isn't something pg_upgrade deals with. If we need docs to move tablespaces, it is a missing piece of our main docs, not something pg_upgrade would ever mention. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
