Re: How to remove non-UTF values from a table?

On Fri, Dec 18, 2009 at 3:54 AM, Bruce Momjian  wrote:
> Bruce Momjian wrote:
>> pg_migrator (not pg_upgrade) has been used by many people to migrate
>> from 8.3 to 8.4.  I just helped someone yesterday with a migration.
>> pg_migrator threw an error because they had reindexed pg_largeobject,
>> and pg_migrator was not prepared to handle that.  They also had an old
>> cluster with a higher autovacuum_freeze_max_age than the new cluster,
>> causing autovacuum freeze to run during the upgrade and remove clog
>> files.  These are unusual cases, so I assume there are many people who
>> successfully use pg_migrator that I never hear from.
>>
>> Both of these issues are fixed in pg_migrator 8.4.6, released yesterday.
>> I also talked to Alvaro about using fixed oids to remove these migration
>> restrictions in 8.5:
>>
>>         o  a user-defined composite data type
>>         o  a user-defined array data type
>>         o  a user-defined enum data type
>>
>> So, pg_migrator is a work in progress.  It current requires migration
>> testing and should be used by experienced Postgres users.  Someday
>> pg_migrator will be easier to use and more reliable.
>
> Oh, and pg_migrator 8.4.6 works for migrations from 8.4 to 8.5 CVS.


Is pg_migrator worth trying between 8.2.9 and 8.4.x?

Thanks