Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 46BD32E3D39 for ; Fri, 14 Dec 2007 14:16:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 07591-01 for ; Fri, 14 Dec 2007 14:16:33 -0400 (AST) Received: from silicio.personal.com.py (smtp.personal.com.py [200.3.250.139]) by postgresql.org (Postfix) with ESMTP id 46A9B2E3BC4 for ; Fri, 14 Dec 2007 14:16:51 -0400 (AST) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgAAALhWYkcKgQIF/2dsb2JhbAAIgx6nEA X-IronPort-AV: E=Sophos;i="4.24,168,1196650800"; d="scan'208";a="1107645" Received: from unknown (HELO mail.personal.net.py) ([10.129.2.5]) by silicio.personal.com.py with ESMTP; 14 Dec 2007 15:16:45 -0300 Received: from asusis-www2 (asusis-www2 [10.129.2.11]) by mail.personal.net.py (Postfix) with SMTP id 955107D2794 for ; Fri, 14 Dec 2007 15:16:44 -0300 (PYST) From: Anibal Acosta To: "pgsql-admin@postgresql.org" Date: 12/14/2007 3:16:45 PM X-MSMail-Priority: Normal X-mailer: AspMail 3.52 (SMTP54636C) Subject: Corrupt backup file after pg_dump (from windows) Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <20071214181644.955107D2794@mail.personal.net.py> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/112 X-Sequence-Number: 27629 Hello guys; Days ago I backup my postgres database using the= PGAdmin program for windows; my postgres version is 8.1. Now; when I try to restore the backup an error occur. ( BTW; I= format my disk; so I can't backup gain :( ) After restore I check the postgres database and I found all= table; functions; and others structures; also data in some= tables but not in all. After some research I detect that I have some "bad blocks" in my= backup file. Those blocks are in the DATA section of a large= table; maybe in a range of 16K. So; when I run the pg_restore everything is restored until the= damaged sector; all information after it is ignored. In the console appear "out of memory". Someones suggest to open the backup file and remove bad rows; but= when I open in any text editor the data is not in a human= readable way. So; maybe you know how can I remove all rows stored in damaged= bytes in order to restore all others rows after it. Thanks!! Anibal