go wrote:
> Hi All!
>
> While restoring PG7.23 dump into PG 8.01 database
> (pg_restore -Fc -d a3 -v arz3.test.dat) i got error:
> pg_restore: ERROR: invalid byte sequence for encoding "UNICODE": 0xfc3535
> CONTEXT: COPY mytable, line 9, column post3: "¦¦ 55146/23.12.04 "
> pg_restore: [archiver (db)] error returned by PQendcopy
> pg_restore: *** aborted because of error
>
> Tell me please how to ignore all errors ?
With bad data? You can't. Are you sure the original database was UNICODE
(UTF8) and not SQL_ASCII encoding?
Try restoring into an SQL_ASCII version 8.0 database, then you can
correct your data and repeat the dump/import. Alternatively, you could
produce a text-file of the dump and correct it with perl/awk/etc.
--
Richard Huxton
Archonet Ltd