From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | friend(dot)have_00(at)icloud(dot)com, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Could not read block 0 in file |
Date: | 2022-04-08 10:01:10 |
Message-ID: | CAM+6J94QEseoZzQ8w7uhidZZ3acf4A2MiHBTWgXd_tuq_h4Z4g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 8 Apr 2022 at 15:24, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>
>
> On Fri, Apr 8, 2022 at 11:06 AM <friend(dot)have_00(at)icloud(dot)com> wrote:
>
>> Hi,
>>
>> While we are looking for a suitable backup to recover from, I hope this
>> community may have some other advice on forward steps in case we cannot
>> restore.
>>
>> RCA: Unexpected shutdown due to critical power failure
>>
>> Current Issue: The file base/16509/17869 is zero bytes in size.
>>
>> The error message when running this query is:
ERROR: could not read block 0 in file "base/16509/17869": read only 0 of
8192 bytes
i guess it is maybe page header/ metadata not the whole file is zero bytes.
the data can be recovered then from the blogs?
i may be corrected :)
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2022-04-08 10:01:24 | Re: Could not read block 0 in file |
Previous Message | Magnus Hagander | 2022-04-08 09:54:16 | Re: Could not read block 0 in file |