Re: Recover corrupted data

From: Alexandre <psybox(at)gmail(dot)com>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Recover corrupted data
Date: 2017-04-19 16:24:32
Message-ID: CAEPSA-e18FVMrUFqdGFCWGsmPnBO+s9vnRY-EkfaO_1VmnfFZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

1) We have a backup but its from the last month, I will try to backup the
data without the table that raises the exception.
2) We dont use RAID.

Thank you

On Wed, Apr 19, 2017 at 12:49 PM, Vick Khera <vivek(at)khera(dot)org> wrote:

> 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 Alexandre 2017-04-19 16:25:41 Re: Recover corrupted data
Previous Message Steve Clark 2017-04-19 16:20:16 Re: Why so long?