Cycling redundancy check error in dump file
Cycling redundancy check error in dump file
От:
Anibal David Acosta <aa@personal.net.py>
Дата:
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