pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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>




Message-ID: <47177BD8.8090605@personal.net.py>
Permalink:  ../47177BD8.8090605@personal.net.py/
Also on:    postgresql.org/message-id/47177BD8.8090605@personal.net.py

 · 

reply

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