8.1: import of 8.0 dump fails with UTF-8 error

Поиск
Список
Период
Сортировка
От Thomas Mueller
Тема 8.1: import of 8.0 dump fails with UTF-8 error
Дата
Msg-id dnhkhn$a2e$1@sea.gmane.org
обсуждение исходный текст
Ответы Re: 8.1: import of 8.0 dump fails with UTF-8 error
Список pgsql-admin
Hello,

I did a pg_dumpall of all my Pg 8.0.3 databases, removed 8.0, installed
8.1 and tried to import the dump. One table in one database failed with:

ERROR:  invalid UTF-8 byte sequence detected near byte 0x83
CONTEXT:  COPY pwd_name, line 22428, column name: "t.tonnement"

So I exported that database with 8.0 as Inserts to a text file and tried
to fix it using iconv, but that fails as well:

# iconv -f UTF-8 -t UTF-8 dump.sql > dump-fixed.sql
iconv: illegal input sequence at position 2588882

How can I fix the sql script to import it?
I have Debian Linux 3.1.


Thanks a lot,
Thomas

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ameet Kini
Дата:
Сообщение: pg_autovacuum log size in postgres v8.0
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: pg_autovacuum log size in postgres v8.0