From: | Alexandre <psybox(at)gmail(dot)com> |
---|---|
To: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Recover corrupted data |
Date: | 2017-04-19 16:25:41 |
Message-ID: | CAEPSA-ffs54m7YKu2sn7pykSVBW8+ax+DSKC1o3KLyvRdMd1AQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It appears to be just one table I'm trying to backup without that table.
But there is no solution for this kind of error?
On Wed, Apr 19, 2017 at 1:11 PM, Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
wrote:
> Il 19/04/2017 17:49, Vick Khera ha scritto:
>
> 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?
>
>
> 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...
> 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.
> Cheers
> Moreno
>
>
>
> 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 | David Rowley | 2017-04-19 17:07:20 | Re: Why so long? |
Previous Message | Alexandre | 2017-04-19 16:24:32 | Re: Recover corrupted data |