Have you tried to restore just schema first, then data?
Greetings,
Zlatko
----- Original Message -----
From: "Howard Cole" <howardnews@selestial.com>
To: "'PgSql General'" <pgsql-general@postgresql.org>
Sent: Friday, December 02, 2005 3:02 PM
Subject: [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.
>
> Regards,
>
> Howard Cole
> www.selestial.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
