Re: pg_upgrade

Tory M Blue wrote:
> On Sat, Dec 3, 2011 at 6:04 AM, Bruce Momjian <bruce(at)momjian(dot)us> 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +