Re: Recover corrupted data

From: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Recover corrupted data
Date: 2017-04-19 16:11:28
Message-ID: e5a313ec-87c3-3a43-2a2b-53eccd911992@evolu-s.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Il 19/04/2017 17:49, Vick Khera ha
scritto:<br>
</div>
<blockquote
cite="mid:CALd+dcdFrJ--Gj2DZqjpbm79zMr1b2GcLPqO_WeqM+Bd7X3YAw(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr">1) restore from backup
<div>2) fix whatever configuration you made to let windows (or
your hardware) destroy your data on crash. is there some RAID
cache that is not backed up by a battery?</div>
</div>
</blockquote>
<br>
IMHO If there's no hurry, it'd be better to start with point 2,
because if your filesystem (or hardware) is somehow badly broken, it
will happen again... <br>
If you have more than one database in your cluster, you can find
what's the database that's been corrupted and restore just that one,
instead of the whole cluster.<br>
Cheers<br>
Moreno
<blockquote
cite="mid:CALd+dcdFrJ--Gj2DZqjpbm79zMr1b2GcLPqO_WeqM+Bd7X3YAw(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr">
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Apr 19, 2017 at 10:18 AM,
Alexandre <span dir="ltr">&lt;<a moz-do-not-send="true"
href="mailto:psybox(at)gmail(dot)com" target="_blank">psybox(at)gmail(dot)com</a>&gt;</span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_default"
style="font-family:verdana,sans-serif">Hello,</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">The computer had
a unexpected shutdown, it is a Windows machine.</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Now some data
appears to be corrupted, I am receiving exceptions like
this:</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">
<div class="gmail_default">ERROR: could not read block 0
in file "base/16393/16485": read only</div>
<div class="gmail_default">0 of 8192 bytes</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">There is some way to correct
this?</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<p><br>
</p>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.9 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2017-04-19 16:20:16 Re: Why so long?
Previous Message Jeff Janes 2017-04-19 15:57:54 Re: Why so long?