Robert Haas wrote:
> > It's certainly the case that there is a lot more work to do before
> > pg_migrator could support everything that we reasonably want to be
> > able to do in a version update. ?As I see it, the reason it's getting
> > revived now is that 8.3->8.4 happens to be an update where most of what
> > it can't (yet) do isn't necessary. ?That means we can get it out there,
> > get the bugs out of the functionality it does have, and most importantly
> > try to set an expectation that future updates will also have some degree
> > of update-in-place capability. ?If we wait till it's perfect then
> > nothing will ever happen at all in this space.
>
> I agree. I remain doubtful that dumping and reloading the schema is
> the best way to go, but it's certainly a worthwhile experiment,
> because (a) I might easily be wrong and (b) we'll hopefully learn some
> things that will be useful going forward.
The amount of work to do an upgrade without dump/reloading the schema is
overly complex and would have to be adjusted for every major release,
with the high likelihood it would not be done or fail in random ways.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +