Re: Recover corrupted data

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Recover corrupted data
Date: 2017-04-19 15:49:28
Message-ID: CALd+dcdFrJ--Gj2DZqjpbm79zMr1b2GcLPqO_WeqM+Bd7X3YAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

1) restore from backup
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?

On Wed, Apr 19, 2017 at 10:18 AM, Alexandre <psybox(at)gmail(dot)com> wrote:

> Hello,
>
> The computer had a unexpected shutdown, it is a Windows machine.
> Now some data appears to be corrupted, I am receiving exceptions like this:
>
> ERROR: could not read block 0 in file "base/16393/16485": read only
> 0 of 8192 bytes
>
> There is some way to correct this?
>

In response to

Responses

Browse pgsql-general by date

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