Re: pg_upgrade - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: pg_upgrade
Date
Msg-id 201112032342.pB3NgRN19536@momjian.us
Whole thread Raw
In response to Re: pg_upgrade  (Tory M Blue <tmblue@gmail.com>)
Responses Re: pg_upgrade  (Bruce Momjian <bruce@momjian.us>)
Re: pg_upgrade  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
List pgsql-performance
Tory M Blue wrote:
> On Sat, Dec 3, 2011 at 6:04 AM, Bruce Momjian <bruce@momjian.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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Question about VACUUM
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade