Re: BUG #3591: autovacuum crash - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3591: autovacuum crash
Date
Msg-id 1871.1188595445@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3591: autovacuum crash  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #3591: autovacuum crash
Next
From: "Ow"
Date:
Subject: BUG #3592: alter function rename to doesn't work