| 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: | Whole Thread | Raw Message | 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 |