Re: FATAL: the database system is in recovery mode

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: FATAL: the database system is in recovery mode
Дата
Msg-id 87r7rnqykv.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Re: FATAL: the database system is in recovery mode  (Ron St-Pierre <rstpierre@syscor.com>)
Список pgsql-general
Ron St-Pierre <rstpierre@syscor.com> writes:

> Jul  7 09:32:58 imp postgres[26784]: [448-1] LOG:  server process (PID
> 32349) was terminated by signal 11

This is the critical event--one of the backends got a segfault.  This
often means bad hardware--either your RAM is faulty, or something got
corrupted on disk and caused a bad pointer reference.  Or maybe an
overheating CPU, if a fan failed.

That said, it's also possible that it's a Postgres bug, but it's more
likely to be hardware...

> Anyway my original question still stands, any idea how to avoid this
> problem in the future?

Test your hardware and replace any bad components.

-Doug

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

Предыдущее
От: Ron St-Pierre
Дата:
Сообщение: Re: FATAL: the database system is in recovery mode
Следующее
От: MargaretGillon@chromalloy.com
Дата:
Сообщение: PGADMIN default storage EXTENDED for Character fields