Bruce Momjian wrote: > 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. FYI, I have asked on the docs list about getting this documented. -- 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
