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

From: Thomas Mueller <news-exp-dec05(at)tmueller(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: 8.1: import of 8.0 dump fails with UTF-8 error
Date: 2005-12-11 16:36:06
Message-ID: dnhkhn$a2e$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matthew T. O'Connor 2005-12-12 00:07:21 Re: pg_autovacuum log size in postgres v8.0
Previous Message Ameet Kini 2005-12-10 22:42:21 pg_autovacuum log size in postgres v8.0