Hi ,
I am working on page corruption issue want to know if below scenario is possible
1) Insert command from client , I understand heap_insert is called from heampam.c
2) Let us say table is full and relation is extended and added a new block
3) Tuple is inserted into new page for the block RelationPutHeapTuple/hio.c
4) Later WAL record is inserted through recptr = XLogInsert(RM_HEAP_ID, info);
5) Then backend update the PageHeader with WAL LSN details PageSetLSN(page, recptr);
If my server got crashed after step 4) is there a possibility that after postgres database restart I get below error when I access the relation or vacuum is run on this relation or taking backup through pg_dump ?
ERROR: invalid page header in block 204 of relation base/16413/16900 ?
or
Postgres can automatically recover the page without throwing any error ?
Appreciate your valuable response on this
Regards
Sreekanth