Category Archives: postgresql

pg_migrator beta-1 released

Version 8.4, Beta 1
What it Does
pg_migrator allows data stored in Postgres data files to be migrated
to a later Postgres major version without the dump/reload of data
typically required for major version upgrades, e.g. 8.3.7 -> 8.4.1.
It is not required for minor version upgrades, e.g. 8.4.1 -> 8.4.5.
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.