detecting metadata corruption after dirty shutdown - Mailing list pgsql-novice

From Matt Kirk
Subject detecting metadata corruption after dirty shutdown
Date
Msg-id 8CD457CA9D370D7-B70-9C7E@webmail-m029.sysops.aol.com
Whole thread Raw
List pgsql-novice

How can I check for metadata corruption in postgres files after a file system event like a repair guy pulling the wrong drive when replacing a failed drive (so breaking the raid set)?  I found pgfsck but it claims to only support up to 8.2.  Would doing a vacuum do it?   pg_dump?  (that takes a long time)

What I'm looking to avoid is having metadata corruption that doesn't get detected for days because the affected tuples aren't touched frequently.

Thanks
Matt

pgsql-novice by date:

Previous
From: niccguard-dev@yahoo.com
Date:
Subject: Upgrade path from 8.2.9 to 9.0
Next
From: m
Date:
Subject: Re: detecting metadata corruption after dirty shutdown