Re: "PANIC: could not open critical system index 2662" - twice

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: "PANIC: could not open critical system index 2662" - twice
Дата
Msg-id 20230407141020.wysn6gnhb7sttl56@hjp.at
обсуждение исходный текст
Ответ на Re: "PANIC: could not open critical system index 2662" - twice  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
On 2023-04-07 13:04:34 +0200, Laurenz Albe wrote:
> On Thu, 2023-04-06 at 16:41 +0000, Evgeny Morozov wrote:
> > What can I do to figure out why this is happening and prevent it from happening again?
>
> No idea about the former, but bad hardware is a good enough explanation.
>
> As to keeping it from happening: use good hardware.

Also: Use checksums. PostgreSQL offers data checksums[1]. Some filesystems
also offer checksums.

This doesn't prevent corruption but at least it will be detected early
and can't spread.

        hp

[1] For some reason I thought the Debian/Ubuntu packages enabled this by
    default. But that doesn't seem to be the case.

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Вложения

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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Patroni vs pgpool II
Следующее
От: Jehan-Guillaume de Rorthais
Дата:
Сообщение: Re: Patroni vs pgpool II