Table with invalid page blocks

From: Gerdan Rezende dos Santos <gerdan(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Table with invalid page blocks
Date: 2015-12-04 17:34:37
Message-ID: CAKOcMA4iq8R-8aiDHUobSHeZ88tRvkB6N4nqcpf1G95VSXaciQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Someone has some way of identifying all invalid blocks of a table postgresql
?
Plpgsql a function, a tool, somehow.

I found one solution on
http://www.postgresql.org/message-id/1184245756.24101.178.camel@coppola.muc.ecircle.de,
but I can not change in order to identify any defective blocks at once.

Postgresql 9.3.10 x64
Red Hat 7 x64

T.'.A.'.F.'.,
*Gerdan Rezende dos Santos *
+55 (61) 9645-1525

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2015-12-04 17:35:21 question about replication slots
Previous Message Yelai, Ramkumar IN BLR STS 2015-12-04 13:21:47 Re: Pgbasebackup help