Re: [GENERAL] PANIC: heap_update_redo: no block

"Qingqing Zhou" <zhouqq@cs.toronto.edu> wrote
>
> "Tom Lane" <tgl@sss.pgh.pa.us> wrote
>>
>> What we should be seeing, and don't see, is an indication of a backup
>> block attached to this WAL record.  Furthermore, I don't see any
>> indication of a backup block attached to *any* of the WAL records in
>> Alex's printout.  The only conclusion I can draw is that he had
>> full_page_writes turned OFF, and as we have just realized that that
>> setting is completely unsafe, that is the explanation for his failure.
>>
>

According to Alex, seems the problem is not because of full_page_writes OFF

>
>> According to the discussion in pgsql-hackers, to finish this case, did 
>> you
>> turn off the full_page_writes parameter? I hope the answer is "yes" ...
>>
>
> If by off you mean full_page_writes = on then yes.


Regards,
Qingqing