Re: Emergency - Need assistance

warren little <warren(dot)little(at)meridiascapital(dot)com> writes:
> The dump/restore failed even with the zero_damaged_pages=true.
> The the logfile (postgresql-2006-01-02_130023.log)
> did not have much in the way of useful info. I've attached the section
> of the logfile around the time of the crash. I cannot find any sign of
> a core file. Where might the core dump have landed?

It would typically go into $PGDATA (if you're using 8.1) or some
subdirectory thereof (if you're using an older release). There are
some platforms such as OS X that put core files in a special directory
/core so check for that too.

If you're not finding any corefile then the most likely bet is that the
postmaster has been launched under "ulimit -c 0" which forbids dropping
a corefile. (This seems to be the default environment under many
Linuxen.) I'd suggest adding "ulimit -c unlimited" to the postmaster
start script you're using, restarting the postmaster, and repeating the
dump to cause the crash again.

regards, tom lane