X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4CB1C9FB218 for ; Tue, 8 Aug 2006 15:36:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 25156-04 for ; Tue, 8 Aug 2006 15:36:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 350159FA621 for ; Tue, 8 Aug 2006 15:36:47 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id n28so346233nfc for ; Tue, 08 Aug 2006 11:36:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=jPhDiFTOstAo3KxnVRmom0YwbO8e1K5Fu9395O60gqxvAkUoFkr2c7qYjamYm1RhuusgrxsR7KKgLydKSnRYSWMeoc++VApzp0S5wc+QJlDRIPRPWupQjmZn/HwI8Zy1j5GGhYZqFIiYlywUdWB1smbnfCOh3ujwoawmC8c0g1A= Received: by 10.78.127.2 with SMTP id z2mr2879204huc; Tue, 08 Aug 2006 11:36:45 -0700 (PDT) Received: by 10.78.32.10 with HTTP; Tue, 8 Aug 2006 11:36:45 -0700 (PDT) Message-ID: Date: Tue, 8 Aug 2006 13:36:45 -0500 From: "Aaron Bono" To: "Benjamin Krajmalnik" Subject: Re: Strange UTF8 issue with pg_dump/pg_restore Cc: "pgsql admin" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14532_6333156.1155062205092" References: X-Google-Sender-Auth: 9e06aeb861b4f551 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.756 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/94 X-Sequence-Number: 22638 ------=_Part_14532_6333156.1155062205092 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/7/06, Benjamin Krajmalnik wrote: > > I have a database whose records are inserted via ODBC. > I turned on logging, and the client is explicitly setting the client > encoding to UTF. > > Rows are inserted into the tables. When I do a pg_dump, I do not get any > errors. When I try tor restore, I am getting an error regarding an invalid > UTF-8 character sequence. > Of course, this renders compressed backups useless, since I have no way of > manually fixing the file. The process of fixing the file is, of course, > painful. > Why can't you manually fix it? I know you cannot fix it while compressed but you should be able to fix it after it is uncompressed, right? Have you tried to set the encoding just like the client before you do a restore from backup? ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_14532_6333156.1155062205092 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/7/06, Benjamin Krajmalnik <kraj@illumen.com> wrote:
I have a database whose records are inserted via ODBC.
I turned on logging, and the client is explicitly setting the client encoding to UTF.
 
Rows are inserted into the tables.  When I do a pg_dump, I do not get any errors.  When I try tor restore, I am getting an error regarding an invalid UTF-8 character sequence.
Of course, this renders compressed backups useless, since I have no way of manually fixing the file.  The process of fixing the file is, of course, painful.

Why can't you manually fix it?  I know you cannot fix it while compressed but you should be able to fix it after it is uncompressed, right?

Have you tried to set the encoding just like the client before you do a restore from backup?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_14532_6333156.1155062205092--