Re: pg_upgrade

Nicholson, Brad (Toronto, ON, CA) wrote:
> > 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.
>
> If I'm reading the issue correctly, and pg_upgrade gets part way through
> an upgrade then fails if it hits a tablespace - it seems to me like
> the pg_upgrade should check for such a condition at the initial
> validation stage not proceed if found.

Checking for all such cases would make pg_upgrade huge and unusable.  If
you messed up your configuration, pg_upgrade can't check for every such
case.  There are thosands of ways people can mess up their configuration.

I think you should read up on how pg_upgrade attempts to be minimal:

    http://momjian.us/main/blogs/pgblog/2011.html#June_15_2011_2

On a related note, Magnus is working on code for Postgres 9.2 that would
allow for easier moving of tablespaces.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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