Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4B61F9FB56F for ; Sat, 7 Apr 2007 18:32:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 35652-01 for ; Sat, 7 Apr 2007 18:32:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by postgresql.org (Postfix) with ESMTP id 732139FB531 for ; Sat, 7 Apr 2007 18:32:19 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id E697F64456B; Sat, 7 Apr 2007 15:32:17 -0600 (MDT) Received: from crestone.coronasolutions.com ([127.0.0.1]) by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21440-01; Sat, 7 Apr 2007 15:32:17 -0600 (MDT) Received: from mac.local (c-67-166-27-159.hsd1.co.comcast.net [67.166.27.159]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by crestone.coronasolutions.com (Postfix) with ESMTP id E49B1644558 for ; Sat, 7 Apr 2007 15:32:16 -0600 (MDT) Message-ID: <46180DE1.2050908@drivefaster.net> Date: Sat, 07 Apr 2007 15:32:17 -0600 From: Dan Harris User-Agent: Thunderbird 2.0b2 (Macintosh/20070116) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Can't restore a pg_dump due to encoding errors References: <46180885.4050504@drivefaster.net> In-Reply-To: <46180885.4050504@drivefaster.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at coronasolutions.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/69 X-Sequence-Number: 25133 Dan Harris wrote: > Hello all: > > I'm in a bit of a bind here. Today is my maintenance window for > upgrading from 8.0.3 to 8.2.3. I did a pg_dumpall overnight ( resulting > in a 72GB file ) and then a pg_dump on one of my small databases this > morning to test pg_restore. When trying to reload, I'm getting the > following error: > > psql:sac.bak:2793776: ERROR: invalid byte sequence for encoding "UTF8": > 0x92 I found the utility 'iconv', which sounds like it addresses this problem. I ran the utility against the dump file and then it loaded without error.. Just validating that the data is indeed there.