Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 354199FA531 for ; Mon, 22 Oct 2007 11:39:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 13834-01-4 for ; Mon, 22 Oct 2007 11:39:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 39C1A9FB811 for ; Mon, 22 Oct 2007 11:39:40 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so912324ugf for ; Mon, 22 Oct 2007 07:39:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=b4PP2kIFinp2r1HCLKaHgeKP/SPr1IVE2AIzscblOIs=; b=ZCQGWa1BeKgGe8F1EnItqG0bpoF34My1X+92HTOXjdE0HDibKL+ezmb1SVicAs2KS1N8662YeWic98GbP9NjM+1FbyK2bRWrjxyA5wIDgNuJgQQzeBDd4NciZUa4hw9v6kSLlu28uGuM9w5Q+7e5b0wqfwfvXMxpbO6cGlBpfCI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CkTx+K5K0wImwzq3LAuJwvEavCmTN1SrGnGZzVPIFv95FoGGo8TEl/2QnfE3uPjblO6zTjeOgX+gYNAOj3fBpJpDFJlHswfSP7UMOrs2Oye+mPkM3JDkeffA+0lIiDM6S9RM3jdZQj36CW8T7RfzTWtsQKZYHL49vf5T1ii3APc= Received: by 10.66.243.2 with SMTP id q2mr6393464ugh.1193063978863; Mon, 22 Oct 2007 07:39:38 -0700 (PDT) Received: by 10.67.29.6 with HTTP; Mon, 22 Oct 2007 07:39:38 -0700 (PDT) Message-ID: Date: Mon, 22 Oct 2007 09:39:38 -0500 From: "Scott Marlowe" To: "Anibal David Acosta" Subject: Re: Please help (backup) Cc: "Phillip Smith" , pgsql-admin@postgresql.org In-Reply-To: <471C9A26.9090302@personal.net.py> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <024701c8147c$55cc9430$9b0014ac@wbaus090> <471C9A26.9090302@personal.net.py> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/210 X-Sequence-Number: 27124 On 10/22/07, Anibal David Acosta wrote: > > Really all file content after object definitions looks like > "Encoded/Encrypted" and when I do a restore all table data are restored > successfully (except one, that is in the "corrupted sector"). So, maybe the > pg_dump do a encrypt or something like that over the DATA content. No. What likely happened is that due to a bug in your OS or harddrive controller, sectors from the middle of a binary (like an executable) got put in place of some of your blocks in your postgresql backup. You need to use a robust editor like vi to chop those parts out and see what you get. But the real answer is to use a known good backup.