Re: BUG #3591: autovacuum crash

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Alvaro Herrera <alvherre(at)commandprompt(dot)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