> 1. find the "core" file at $PGDATA/base/yourdbnum/core (if not there,
> restart postmaster with "ulimit -c unlimited" context and cause problem
> again).
>
> 2. gdb /path/to/postgres /path/to/core
> bt
> quit
>
Thank you a lot! Tom,
I am not sure if this helps diagnose.
Regards,
CN
==============================
Attaching to process 16985
ptrace: No such process.
Core was generated by `postgres: d'.
Program terminated with signal 11, Segmentation fault.
#0 0x0817c540 in ?? ()
(gdb) bt
#0 0x0817c540 in ?? ()
#1 0x080badfb in ?? ()
#2 0x080ba8f1 in ?? ()
#3 0x081285c9 in ?? ()
#4 0x081263e4 in ?? ()
#5 0x081275b5 in ?? ()
#6 0x0810e70f in ?? ()
#7 0x0810df15 in ?? ()
#8 0x0810d07a in ?? ()
#9 0x0810cbcf in ?? ()
#10 0x080e9257 in ?? ()
#11 0x400df5c6 in ?? ()
(gdb) quit
--
http://fastmail.fm - Accessible with your email software
or over the web