X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BBC3F9DD569 for ; Sun, 11 Dec 2005 16:27:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30401-04 for ; Sun, 11 Dec 2005 16:27:17 -0400 (AST) X-Greylist: delayed 03:03:32.964573 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id 744DA9DD44C for ; Sun, 11 Dec 2005 16:27:13 -0400 (AST) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr2.postgresql.org (Postfix) with ESMTP id 54B17F0B38 for ; Sun, 11 Dec 2005 17:23:38 +0000 (GMT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1ElUsg-00082Y-EL for pgsql-admin@postgresql.org; Sun, 11 Dec 2005 18:21:02 +0100 Received: from p54a18dbe.dip0.t-ipconnect.de ([84.161.141.190]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 11 Dec 2005 18:21:02 +0100 Received: from news-exp-dec05 by p54a18dbe.dip0.t-ipconnect.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 11 Dec 2005 18:21:02 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Thomas Mueller Subject: 8.1: import of 8.0 dump fails with UTF-8 error Date: Sun, 11 Dec 2005 17:36:06 +0100 Lines: 20 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: p54a18dbe.dip0.t-ipconnect.de User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-DE; rv:1.7.12) Gecko/20051013 Thunderbird/1.0.7 Mnenhy/0.7.3.0 X-Accept-Language: de-DE, de, en-us, en X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/85 X-Sequence-Number: 19805 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