Postgres Pro
Downloads
Home   >   mailing lists

pg_restore UTF8 problem - Mailing list pgsql-general

From Thomas Burns
Subject pg_restore UTF8 problem
Date
Msg-id 9B63A4D0-8A26-42D3-AC3C-58901E3A707F@schoolloop.com
Whole thread Raw
Responses Re: pg_restore UTF8 problem
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: ptjm@interlog.com (Patrick TJ McPhee)
Date:
Subject: Re: Porting MySQL data types to PostgreSQL
Next
From: Alessandra Bilardi
Date:
Subject: could not [extend relation|write block N of temporary file|write to hash-join temporary file]