[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Invalid page header in block 25561983 of relation pg_tblspc
From:       Michael Paquier <michael.paquier () gmail ! com>
Date:       2016-12-27 11:01:04
Message-ID: CAB7nPqRONX+dwnGUnFJWoRQ2VYDetR8mO8vmz0mH-SUHdfOVsQ () mail ! gmail ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]