Craig McElroy <craig(dot)mcelroy(at)contegix(dot)com> writes:
>> Can you get a stack trace from the core dump reported here?
> Certainly, how can that be obtained?
$ gdb /path/to/postgres-executable /path/to/core-file
gdb> bt
gdb> quit
If you don't find a corefile in $PGDATA (or wherever your system puts
core files) then you probably need to restart the postmaster with
"ulimit -c unlimited" to allow producing a core.
If the "bt" output is just numbers and no symbols then it won't be of
any use; in that case you'll need to find or build non-stripped Postgres
executables.
regards, tom lane