Re: BUG #3591: autovacuum crash

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3591: autovacuum crash
Дата
Msg-id 1871.1188595445@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #3591: autovacuum crash  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Ben Kim wrote:
>> PostgreSQL version: 8.1.0
>> The server crashed suddenly the second time since two days ago. ulimit is
>> unlimited, but I see no core file under the postgresql root directory.

> This is a crash all right, but I think we fixed a certain number of bugs
> after 8.1.0 was released.

Indeed.

> FWIW the core files should be stored in the data directories (PGDATA).

It seems likely that ulimit -c may be limited for the postmaster even if
it is not in your interactive shell --- very many systems run init
scripts with ulimit -c 0.  I'd suggest putting "ulimit -c unlimited"
right in the script that launches the postmaster.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #3591: autovacuum crash
Следующее
От: "Ow"
Дата:
Сообщение: BUG #3592: alter function rename to doesn't work