pg_restore UTF8 problem
Hi,
I ran into a problem while restore a database. I am converting a
database from SQLASCII to UTF8. The pg_restore fails with:
pg_restore: ERROR: invalid UTF-8 byte sequence detected near byte 0xe7
CONTEXT: COPY sl_email_messages, line 119593, column message: "In
Reply To:get a life
and terminates. What I would like to happen is for pg_restore to
ignore this error and continue on. Is there a way to make it do that?
Tom Burns
Thomas Burns wrote:
I ran into a problem while restore a database. I am converting a
database from SQLASCII to UTF8. The pg_restore fails with:pg_restore: ERROR: invalid UTF-8 byte sequence detected near byte
0xe7 CONTEXT: COPY sl_email_messages, line 119593, column message:
"In Reply To:get a lifeand terminates. What I would like to happen is for pg_restore to
ignore this error and continue on. Is there a way to make it do
that?
No, you have to find out which encoding that actually is and then set
your client encoding to that when restoring.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/