Re: pg_upgrade project status

Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > Now that pg_migrator is BSD licensed, and already in C, I am going to
> > spend my time trying to improve pg_migrator for 8.4:
> > 
> >     http://pgfoundry.org/projects/pg-migrator/
> 
> What is the plan now?  Get pg_upgrade working, get pg_migrator working, 
> ship pg_migrator in core or separately?  Is there any essential 
> functionality that we need to get into the server code before release? 
> Should we try to get dropped columns working?  It's quite late to be 
> wondering about this, so unless we get a clear and definite plan this 
> week, I say we stop kidding ourselves and drop it.

Oh, a plan?  ;-)

Basically I am trying to add functionality to the code and clean it up
so it is easier to maintain.  You can grab the CVS to see my current
version:
http://pgfoundry.org/scm/?group_id=1000235

Everyone seemed to prefer a migration utility in C, and pg_migrator is
in C so I am working on that.  It has a BSD license now so we could
include it if we wanted to.

I am working on pg_migrator TODO items.  My current list is:
o  Makefiles are not yet complete.o  need to check crc when we reading the pg_control fileo  compare the pg_controls of
oldand new serverso  fix loaded tables with dropped columns;  the dropped column location   is not   part of pg_dump;
pg_attribute.attisdroppedmust be checked and a   replacement   table created and the column droppedo  must call vacuum
freezeon system tables before clog is copiedo  restore pg_database.datfrozenxid to their original valueso  restore
pg_class.relfrozenxidto their original values
 

I am not sure about the first two items, but I want to try to address
the other ones, though I am not sure how to handle the drop column case.

Once I am complete the existing TODOs I will start on testing and
getting more feedback on missing features.

If folks want to help out, please let me know.

I am not aware of any server changes needed for 8.3-8.4 migration.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +