X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B948D9FB393 for ; Fri, 4 Aug 2006 11:35:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 44297-01 for ; Fri, 4 Aug 2006 14:35:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C74499FB0D1 for ; Fri, 4 Aug 2006 11:35:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mead.wulfsberg.com (unknown [216.185.173.34]) by svr4.postgresql.org (Postfix) with ESMTP id 0BFE35AF032 for ; Fri, 4 Aug 2006 14:35:16 +0000 (GMT) Received: from [10.0.3.243] (esperante.wulfsberg.com [10.0.3.243]) (authenticated bits=0) by mead.wulfsberg.com (8.12.8/8.12.8) with ESMTP id k74EZDR5003823 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Fri, 4 Aug 2006 07:35:14 -0700 Message-ID: <44D35B24.4040503@wulfsberg.com> Date: Fri, 04 Aug 2006 07:35:16 -0700 From: Karen Springer Organization: Wulfsberg Electronics User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Need to upgrade postgres 7.4 to 8.1 References: <45BBA6DE339CFF41821CAF2E3314AAAA1C73CB@nea-hq-x1.nea.loc> In-Reply-To: <45BBA6DE339CFF41821CAF2E3314AAAA1C73CB@nea-hq-x1.nea.loc> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/37 X-Sequence-Number: 22581 I had the same problem last week. iconv cleaned up my dump file, but removed characters I actually wanted (degree & micro symbols). I tried changing the encoding to Latin1 in my pg_dumpall file. This did seem to help some, though there was still a problem with some of the characters. I finally ended up fixing the data. In our case I think the invalid characters were created when we did transfers from Cadstar into Access & then into Postgres. The characters were not true degree & micro UTF-8 characters, but junk that still looked ok in Access & Postgres 7.4. Karen JKapustik@nea.org wrote: > Need Help. Need to upgrade our postgres 7.4 database to 8.1 in order to > upgrade our Lyris Listmanager from 8.1 to 9. I am running into > problems. I get invalid UTF-8 byte sequences. We are running Linux > RedHat AS3. The database dump is 4.5 Gig. I tried the command iconv -c > -f UTF-8 -t UTF-8 -o cleanfile postdump. It said 'file too large'. > Note, I used postgres 8.1 pg_dump command that is recommended.. Any > suggestions? Thanks, John > > John Kapustik > Systems Administrator > Office (202) 822 7531 > Cell (202) 285 5163 > ******************************************************************* > Only the individual sender is responsible for the content of the > message, and the message does not necessarily reflect the position > or policy of the National Education Association or its affiliates. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly