Re: Undetected corruption of table files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Undetected corruption of table files
Дата
Msg-id 8963.1187888881@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Undetected corruption of table files  ("Albe Laurenz" <all@adv.magwien.gv.at>)
Список pgsql-general
"Albe Laurenz" <all@adv.magwien.gv.at> writes:
> - Shouldn't there be an error, some kind of 'missing magic
>   number' or similar, when a table file consists of only
>   zeros?

The particular case of an all-zeroes page is specifically allowed,
and has to be because it's a valid transient state in various
scenarios.

> - Wouldn't it be desirable to have some means to verify the
>   integrity of a table file or a whole database?

SELECT * usually does reasonably well at that.

            regards, tom lane

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

Предыдущее
От: "Max Zorloff"
Дата:
Сообщение: Apache + PHP + Postgres Interaction
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Argument type list