Re: Could not read block 0 in file
| От | Vijaykumar Jain |
|---|---|
| Тема | Re: Could not read block 0 in file |
| Дата | |
| Msg-id | CAM+6J94QEseoZzQ8w7uhidZZ3acf4A2MiHBTWgXd_tuq_h4Z4g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Could not read block 0 in file (Magnus Hagander <magnus@hagander.net>) |
| Ответы |
Re: Could not read block 0 in file
|
| Список | pgsql-general |
On Fri, 8 Apr 2022 at 15:24, Magnus Hagander <magnus@hagander.net> wrote:
On Fri, Apr 8, 2022 at 11:06 AM <friend.have_00@icloud.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 failureCurrent 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 :)
В списке pgsql-general по дате отправления: