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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
