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