Re: Bus error in postgres 8.3 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Bus error in postgres 8.3
Date
Msg-id 25410.1209448864@sss.pgh.pa.us
Whole thread Raw
In response to Bus error in postgres 8.3  ("Peter Koczan" <pjkoczan@gmail.com>)
Responses Re: Bus error in postgres 8.3  ("Peter Koczan" <pjkoczan@gmail.com>)
Re: Bus error in postgres 8.3  ("Filip Svendsen" <fs@basepointmedia.com>)
List pgsql-admin
"Peter Koczan" <pjkoczan@gmail.com> writes:
> I'm going to try to force a crash on my test server to see if I can
> find out anything more. Does anyone know how to get useful debugging
> info at the time of the crash? I don't think I have things set to dump
> core anywhere, but that and/or stack traces would be nice (especially
> for child processes).

Make sure the postmaster is started under ulimit -c unlimited.
On a depressingly large fraction of modern platforms, daemons are
started with ulimit -c 0 by default :-(.  Try putting "ulimit -c unlimited"
into your PG init script and restarting.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: Bus error in postgres 8.3
Next
From: "Pavan Deolasee"
Date:
Subject: Re: Bus error in postgres 8.3