detecting metadata corruption after dirty shutdown

Поиск
Список
Период
Сортировка
Искать
От
Matt Kirk
Тема
detecting metadata corruption after dirty shutdown
Дата
Msg-id
8CD457CA9D370D7-B70-9C7E@webmail-m029.sysops.aol.com
Список
Дерево обсуждения
Re: detecting metadata corruption after dirty shutdown m <mbkirk1024@aim.com>
Re: detecting metadata corruption after dirty shutdown m <mbkirk1024@aim.com>

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 по дате отправления
От: niccguard-dev@yahoo.com
Дата:
Сообщение: Upgrade path from 8.2.9 to 9.0
От: m
Дата:
FAQ