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 <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
