Have you tried to restore just schema first, then data?
Greetings,
Zlatko
----- Original Message -----
From: "Howard Cole" <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
