detecting metadata corruption after dirty shutdown

From: Matt Kirk <mbkirk1024(at)aim(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: detecting metadata corruption after dirty shutdown
Date: 2010-10-29 12:33:45
Message-ID: 8CD457CA9D370D7-B70-9C7E@webmail-m029.sysops.aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How can I check for metadata corruption in postgres files after a filesystem event like a repair guy pulling the wrong drive when replacing afailed drive (so breaking the raid set)? I found pgfsck but it claimsto 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'tget detected for days because the affected tuples aren't touchedfrequently.

Thanks

Matt

Browse pgsql-novice by date

  From Date Subject
Next Message m 2010-10-29 14:23:05 Re: detecting metadata corruption after dirty shutdown
Previous Message niccguard-dev 2010-10-28 19:34:33 Upgrade path from 8.2.9 to 9.0