| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Thomas Burns <tombu(at)schoolloop(dot)com> |
| Subject: | Re: pg_restore UTF8 problem |
| Date: | 2007-08-04 15:08:27 |
| Message-ID: | 200708041708.28109.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-04 15:31:10 | Re: Safe usage of tsearch2: to_tsquery('<user input>') |
| Previous Message | Peter Eisentraut | 2007-08-04 15:05:59 | Re: Restrict access |