Would like to below scenario is possible for getting page/block corruption

From: Sreekanth Palluru <sree4pg(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Would like to below scenario is possible for getting page/block corruption
Date: 2016-12-09 00:46:07
Message-ID: CAP+fnpj3J_6dczUvmGvjQoc=-zYhg2YiKFXCHLrvWLo7MM53_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Paquier 2016-12-09 01:01:15 Re: Would like to below scenario is possible for getting page/block corruption
Previous Message Peter Eisentraut 2016-12-08 13:55:20 Re: Are dns CNAME's allowed or useable in pg_hba.conf hostname specification

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2016-12-09 00:47:56 Re: Importing SQLite database
Previous Message Adrian Klaver 2016-12-09 00:45:39 Re: Looking for an online mentor