warren little <warren.little@xxxxxxxxxxxxxxxxxxx> 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
