Re: pg_restore UTF8 problem - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: pg_restore UTF8 problem
Date
Msg-id 200708041708.28109.peter_e@gmx.net
Whole thread Raw
In response to pg_restore UTF8 problem  (Thomas Burns <tombu@schoolloop.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Restrict access
Next
From: Tom Lane
Date:
Subject: Re: Safe usage of tsearch2: to_tsquery('')