Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id AC6489F9B50 for ; Sun, 21 Oct 2007 22:16:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 02291-06 for ; Sun, 21 Oct 2007 22:16:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.devshock.com (mail.guaijole.com [201.217.17.101]) by postgresql.org (Postfix) with SMTP id 9A5D89F995D for ; Sun, 21 Oct 2007 22:16:24 -0300 (ADT) Received: from [10.1.1.2] ([200.61.226.106]) by mail.devshock.com with hMailServer ; Sun, 21 Oct 2007 21:16:08 -0400 Message-ID: <471BF9DB.2010301@personal.net.py> Date: Sun, 21 Oct 2007 21:16:11 -0400 From: Anibal David Acosta User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Please help (backup) References: <1192777762.618697.226800@e34g2000pro.googlegroups.com> <1192860050.514202.74290@v23g2000prn.googlegroups.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.73 tagged_above=0 required=5 tests=AWL=0.729, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200710/202 X-Sequence-Number: 27116 I have a backup done with "pg_dump" utility. For some reason the backup file has 8 phisical bad sectors (17 KB of data) Now when I try to restore the backup all tables are created successfully and data of almost all tables restores successfully too, but one table (the most important) appear empty. When I do a pg_restore its show all sql instructions and data until arrive to the "damaged sector" and throws a "out of memory" exception. I want to know if is possible to fix the backup file removing the blocks in the "bad sectors" in order to restore all other information. something like file dump surgery :) Thanks! Anibal