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 |