Re: pg_upgrade project status

Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> Heikki Linnakangas píše v st 28. 01. 2009 v 09:24 +0200:
>> Right, the dump+initdb+reload approach works quite well in both 
>> pg_upgrade and pg-migrator. I believe the biggest issue with that ATM is 
>> supporting dropped columns, and maybe there's something else, but it's 
>> fairly robust and works across any versions.

> It works but it is not ideal.

Sure, but the other way is just a complete non-starter.  It's enormous
amounts of work even for simple changes, and it's not hard to think of
potentially-desirable catalog rearrangements for which it would be
completely unworkable.

> I have idea how to do it without old PostgreSQL version and with
> bootstrap process extension which should not be invasive and easily
> maintainable. I will send idea latter ... stay tuned ;-)

New ideas welcome of course.
        regards, tom lane