Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 617A59FC153 for ; Thu, 18 Oct 2007 13:30:17 -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 09896-05 for ; Thu, 18 Oct 2007 13:30:09 -0300 (ADT) X-Greylist: delayed 01:00:36.655193 by SQLgrey-1.7.5 Received: from mail.devshock.com (mail.guaijole.com [201.217.17.101]) by postgresql.org (Postfix) with SMTP id 68E7C9FC1B1 for ; Thu, 18 Oct 2007 13:30:09 -0300 (ADT) Received: from [10.1.1.3] ([200.61.226.106]) by mail.devshock.com with hMailServer ; Thu, 18 Oct 2007 11:29:21 -0400 Message-ID: <47177BD8.8090605@personal.net.py> Date: Thu, 18 Oct 2007 11:29:28 -0400 From: Anibal David Acosta User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Cycling redundancy check error in dump file Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.459 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001, MIME_HTML_ONLY=1.457 X-Spam-Level: * X-Archive-Number: 200710/176 X-Sequence-Number: 27090 Hello guys, recently I made a backup of my entire database using pg_dump.

The backup was OK, but for some reason when I make the copy in my storage device the back was copy wrong or something else.

Whe I try to copy the file from my storage a "Cycling reduncandy check error appear", Finally I made the copy to my hard disk but with some damaged sectors.

I don't have the original database :(( only the dump file.

When I try to restore, everything works fine, all tables are created, and populated, all except two tables (big tables, in respect the others (not really big)).

When the pg_restore tried to copy data from the dump to my table "A" an "out of memory" exception occurr, (maybe is the damaged section).

So, I would like to "skip" those sectors (maybe deleting damaged rows) an insert all others.

Please help me.. I don't found too much documentation about it.

Thanks


Anibal