Re: pg_upgrade

Bruce Momjian wrote:
> 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.

FYI, I have asked on the docs list about getting this documented.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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