Check for corruptions - Mailing list pgsql-admin

From Marc Mamin
Subject Check for corruptions
Date
Msg-id CA896D7906BF224F8A6D74A1B7E54AB3039E89DF@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: Migration from ASCII to UTF8  (Ivo Rossacher <rossacher@bluewin.ch>)
List pgsql-admin
 Hi,


We have an issue with a database on IP SAN disks (Solaris x64), where
some tables and indexes got corrupted, apparently in correlation with
the use of forcedirectio in the nfs for data and indexes:

   ERROR:  unexpected data beyond EOF in block ...
   HINT:   This has been seen to occur with buggy kernels; consider
updating your system.

Now I'm interested in a way to get the list of all corrupted objects.
The only way I know is to check the errors of pg_dump or vacuum.
Is there a faster way, something like "vacuum check_only" ?

Thanks,

Marc Mamin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: FATAL Authentication
Next
From: Alvaro Herrera
Date:
Subject: Re: Is it possible to convert WAL's between architectures?