Re: unexpected shutdown

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: unexpected shutdown
Дата
Msg-id 4003.1182197958@sss.pgh.pa.us
обсуждение исходный текст
Ответ на unexpected shutdown  (developer@wexwarez.com)
Ответы Re: unexpected shutdown  (developer@wexwarez.com)
Список pgsql-general
developer@wexwarez.com writes:
> My database has shutdown several times in the last couple days.  I have no
> idea why.  I am running centos and I have not rebooted the server or made
> any configuration changes.

So in particular, you didn't disable memory overcommit?

> LOG:  server process (PID 501) was terminated by signal 9

If you didn't issue a manual kill -9, then this is almost certainly a
trace of the kernel OOM killer at work.  Google for "OOM kill" to learn
more, or see "memory overcommit" in the PG docs.

Memory overcommit is evil on a server.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: time without time zone
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore out of memory