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?
>>
>
>
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? |