Thread: 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 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?

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/