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 file
o compare the pg_controls of old and new servers
o fix loaded tables with dropped columns; the dropped column location
is not
part of pg_dump; pg_attribute.attisdropped must be checked and a
replacement
table created and the column dropped
o must call vacuum freeze on system tables before clog is copied
o restore pg_database.datfrozenxid to their original values
o restore pg_class.relfrozenxid to 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +