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

Phoenix Kiula wrote:
> On Fri, Dec 18, 2009 at 3:54 AM, Bruce Momjian <bruce(at)momjian(dot)us> 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?

No, it only handles 8.3 and later.

--
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. +