Re: Detecting corrupted pages earlier

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Detecting corrupted pages earlier
Дата
Msg-id 23593.1045581717@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Detecting corrupted pages earlier  (Kevin Brown <kevin@sysexperts.com>)
Ответы Re: Detecting corrupted pages earlier
Список pgsql-hackers
Kevin Brown <kevin@sysexperts.com> writes:
> Tom Lane wrote:
>> The cases I've been able to study look like the header and a lot of the
>> following page data have been overwritten with garbage --- when it made
>> any sense at all, it looked like the contents of non-Postgres files (eg,
>> plain text), which is why I mentioned the possibility of disks writing
>> data to the wrong sector.

> That also sounds suspiciously like the behavior of certain filesystems
> (Reiserfs, for one) after a crash when the filesystem prior to the
> crash was highly active with writes.

Isn't reiserfs supposed to be more crash-resistant than ext2, rather
than less so?

> Had the sites that reported this
> experienced OS crashes or power interruptions?

Can't recall whether they admitted to such or not.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: pg environment? metadata?
Следующее
От: Justin Clift
Дата:
Сообщение: Re: FW: Changing the default configuration (was Re: