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