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.. "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! Thanks again Tory -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
