pg_migrator status for 8.4

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: pg_migrator status for 8.4
Date: 2009-06-03 13:24:33
Message-ID: 200906031324.n53DOXs11939@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-06-03 13:37:52 Re: Locks on temp table and PREPARE
Previous Message Emmanuel Cecchet 2009-06-03 13:15:50 Re: Locks on temp table and PREPARE