From: Anibal David Acosta <aa@personal.net.py>
To: pgsql-admin@postgresql.org
Subject: Cycling redundancy check error in dump file
Date: Thu, 18 Oct 2007 11:29:28 -0400
Message-ID: <47177BD8.8090605@personal.net.py> (raw)
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Verdana">Hello guys, recently I made a
backup of my entire database using pg_dump.<br>
<br>
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.<br>
<br>
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.<br>
<br>
I don't have the original database :(( only the dump file.<br>
<br>
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)).<br>
<br>
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).<br>
<br>
So, I would like to "skip" those sectors (maybe deleting damaged rows)
an insert all others.<br>
<br>
Please help me.. I don't found too much documentation about it.<br>
<br>
Thanks<br>
<br>
<br>
Anibal<br>
<br>
</font></font>
</body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aa@personal.net.py
Subject: Re: Cycling redundancy check error in dump file
In-Reply-To: <47177BD8.8090605@personal.net.py>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox