Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7792F64FC28 for ; Sat, 27 Sep 2008 04:22:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06699-03 for ; Sat, 27 Sep 2008 04:22:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.238]) by postgresql.org (Postfix) with ESMTP id 882D764FC0F for ; Sat, 27 Sep 2008 04:22:20 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so1191935rvf.43 for ; Sat, 27 Sep 2008 00:22:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=Oa/g6xKaLC6+PI9Umjp/9MCM7olTG52f2gO9N3B3zVo=; b=md2KSD5a4nob/XsKv7sMesQPz616PYcsPGCOxwG6nmGso9hhKl2OvkslBYxISGPBV+ kXteETF4kdgCNwWaWPu2j6cDQpT+Jl+uYr9dmxxUEUPRKS1JZGOoAwtUqRbNnW2XDrmZ iHFnsvTcKliPxmpo+Ult3+ILs56PjLKJLAeGs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Thx5R6aazC60L4SLOLmqTan8798qBhjVkUCEIaEAi0ZLl0DdHHtbQsIkujOHo6gHoz rC2+6MnGHxw4eSbPVqrybQlxyn83aa426NZBrfeFWsMOFu45M0y5/lt1i9SFAqxR/E2p qUGdcKeCOBxZ3SAqlOhXYZfpV5VJg3HlKW6DY= Received: by 10.141.76.21 with SMTP id d21mr1202352rvl.242.1222500138852; Sat, 27 Sep 2008 00:22:18 -0700 (PDT) Received: by 10.140.131.10 with HTTP; Sat, 27 Sep 2008 00:22:18 -0700 (PDT) Message-ID: <57a815bf0809270022x49bfe795r1bcedbd7ffd7493b@mail.gmail.com> Date: Sat, 27 Sep 2008 17:22:18 +1000 From: "Mikel Lindsaar" To: "Tore Halset" , pgsql-admin@postgresql.org Subject: Re: unable to restore 8.2.5 In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <35E76852-E52D-4BE7-9931-7B1AE6805248@pvv.ntnu.no> <57a815bf0809190637h49abd565x108ce52bc92a9d0a@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/322 X-Sequence-Number: 30415 On Fri, Sep 26, 2008 at 7:12 PM, Tore Halset wrote: > Thanks a lot! Using the script, I found the entries with invalid UTF-8 and > fixed them in the database. That's great news. You are welcome. Curious, how long did it take to run on your entire table? You mentioned it was fairly big. Mikel