Re: Unicode Corruption and upgrading to 8.0.4. to 8.1

Hello!

> -----Ursprüngliche Nachricht-----
> Von: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] Im Auftrag von Howard Cole
> Gesendet: Dienstag, 6. Dezember 2005 13:41
> An: 'PgSql General'
> Betreff: Re: [GENERAL] Unicode Corruption and upgrading to
> 8.0.4. to 8.1

> >> Hi everyone, I have a problem with corrupt UTF-8 sequences in my
> >> 8.0.4 dump which is preventing me from upgrading to 8.1 -
> which spots
> >> the errors and refuses to import the data. Is there some
> SQL command
> >> that I can use to fix or cauterise the sequences in the 8.0.4
> >> database before dumping to 8.1?
> >>
> >> I think the problem arose using invalid client encodings -
> which were
> >> not rejected prior to 8.1.


We experienced the exact same problems. You may solve the problem by feeding the dump through iconv. See my earlier
messageon this issue 

http://archives.postgresql.org/pgsql-general/2005-11/msg00799.php

On top of that you'd be well advised to try dumping using pg_dump of postgresql 8.1.

Kind regards

   Markus