Re: Elusive segfault with 9.3.5 & query cancel

Peter Geoghegan <pg(at)heroku(dot)com> writes:
> On Fri, Dec 5, 2014 at 2:41 PM, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com> wrote:
>> Perhaps we should also officially recommend production servers be setup to
>> create core files. AFAIK the only downside is the time it would take to
>> write a core that's huge because of shared buffers

> I don't think that's every going to be practical.

I'm fairly sure that on some distros (Red Hat, at least) there is distro
policy against having daemons produce core dumps by default, for multiple
reasons including possible disk space consumption and leakage of secure
information. So even if we recommended this, the recommendation would be
overridden by some/many packagers.

There is much to be said though for trying to emit at least a minimal
stack trace into the postmaster log file. I'm pretty sure glibc has a
function for that; dunno if it's going to be practical on other platforms.

regards, tom lane