| From: | "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Check for corruptions |
| Date: | 2008-06-05 11:50:45 |
| Message-ID: | CA896D7906BF224F8A6D74A1B7E54AB3039E89DF@JENMAIL01.ad.intershop.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-06-05 15:19:32 | Re: Is it possible to convert WAL's between architectures? |
| Previous Message | Tom Lane | 2008-06-04 20:42:29 | Re: FATAL Authentication |