On Tue, Dec 27, 2016 at 6:24 PM, Dinesh Chandra 12108 <dinesh.chan...@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
