Thread: [PERFORM] Invalid page header in block 25561983 of relation pg_tblspc
[PERFORM] Invalid page header in block 25561983 of relation pg_tblspc
From
Dinesh Chandra 12108
Date:
Dear Expert,
I am getting the below error in my database.
ERROR: invalid page header in block 25561983 of relation pg_tblspc/55703433/PG_9.1_201105231/55703436/113490260
Can you please suggest me how to resolve it? I think its related to block corruption.
How can I find particular block in which table? And how to resolve that particular block issue.
Thanks in adwance
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
------------------------------------------------------------------
Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com
Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
DISCLAIMER:
This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Check all attachments for viruses before opening them. All views or opinions presented in this e-mail are those of the author and may not reflect the opinion of Cyient or those of our affiliates.
Re: [PERFORM] Invalid page header in block 25561983 of relation pg_tblspc
From
Michael Paquier
Date:
On Tue, Dec 27, 2016 at 6:24 PM, Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com> wrote: > Can you please suggest me how to resolve it? I think its related to block > corruption. You may want to roll in a backup, and move to a different server: https://wiki.postgresql.org/wiki/Corruption > How can I find particular block in which table? And how to resolve that > particular block issue. pg_filenode_relation() is your friend: https://www.postgresql.org/docs/9.6/static/functions-admin.html#FUNCTIONS-ADMIN-DBOBJECT > DISCLAIMER: > > This email message is for the sole use of the intended recipient(s) and may > contain confidential and privileged information. Any unauthorized review, > use, disclosure or distribution is prohibited. If you are not the intended > recipient, please contact the sender by reply email and destroy all copies > of the original message. Check all attachments for viruses before opening > them. All views or opinions presented in this e-mail are those of the author > and may not reflect the opinion of Cyient or those of our affiliates. #fail. This is a public mailing list. -- Michael