Re: restoreing dumps fail

=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin(at)bugs(dot)unl(dot)edu(dot)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