pg_migrator beta-1 released

pg_migrator

———–

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.

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.

Download

————-

Leave a comment