=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:
> 2002-05-14 10:23:36 DEBUG: child process (pid 15137) was terminated by signal
> 10
Hmm, apparently a bus error?
> About the trace of the core, first I don't know exactly what to do, and
> second, I can't find a core file (or does it have another name?)
It should be named core (or some variant; some platforms include the PID
or the program name, but pretty much everybody includes "core" in the
name). And it will definitely be located in $PGDATA/base/yourdbnumber/.
If you don't see one there then you probably started the postmaster with
ulimit -c 0. Change to ulimit -c unlimited and try again.
Once you get a core do
gdb $INSTALL/bin/postgres $PGDATA/base/yourdbnumber/core
gdb> bt
gdb> quit
If the bt produces only a list of numbers and no symbolic info then
it will be little help. In that case, please recompile Postgres with
debug support (configure --enable-debug) and try again.
regards, tom lane