Re: [GENERAL] Recover corrupted data - Mailing list pgsql-general

From Vick Khera
Subject Re: [GENERAL] Recover corrupted data
Date
Msg-id CALd+dcdFrJ--Gj2DZqjpbm79zMr1b2GcLPqO_WeqM+Bd7X3YAw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Recover corrupted data  (Alexandre <psybox@gmail.com>)
Responses Re: [GENERAL] Recover corrupted data  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Re: [GENERAL] Recover corrupted data  (Alexandre <psybox@gmail.com>)
List 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@gmail.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?

pgsql-general by date:

Previous
From: Steve Clark
Date:
Subject: Re: [GENERAL] Why so long?
Next
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Why so long?