I believe pg_migrator has advanced as far as it is going to for 8.4 and
I am expecting to enter beta next week. Here are the known pg_migrator
limitations:
---------------------------------------------------------------------------
Currently pg_migrator only supports upgrades from 8.3.X to 8.4.X.
pg_migrator will not work if:
o a user column is of data type tsquery o a user column is of data type 'name' and is not the first
column
pg_migrator will require a table rebuild if:
o a user column is of data type tsvector
pg_migrator will require a reindex if:
o an index is of type hash or gin o an index uses bpchar_pattern_ops
All failure, rebuild, and reindex cases will be reported by pg_migrator
if they affect your installation; post-migration scripts to rebuild
tables and indexes will be automatically generated.
In general it is unsafe to access tables referenced in rebuild scripts
until the rebuild scripts have run to completion; doing so could yield
incorrect results or poor performance. Tables not referenced in rebuild
scripts can be accessed immediately.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +