Pierre-Yves LANDURE <pylandur(at)ifremer(dot)fr> writes:
> and, to ask a stupid question..... How can i do a stack trace ;))))
Something like
gdb /path/to/postgres-executable /path/to/corefile
gdb> bt
gdb> quit
If you do not see a core file in the $PGDATA/base/yourdbnumber/
directory, you probably are running the postmaster with core dumps
disabled by ulimit. Try setting "ulimit -c unlimited" in the
script that starts it.
If the bt command produces a bunch of numbers and no routine names, you
need to recompile with debug symbols --- rerun configure adding
"--enable-debug", then rebuild and reinstall.
regards, tom lane