Peter Geoghegan <p...@heroku.com> writes: > On Fri, Dec 5, 2014 at 2:41 PM, Jim Nasby <jim.na...@bluetreble.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers