Thanks for your help on this. The trace details are as follows:
Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'.
Program terminated with signal 11, Segmentation fault.
#0 0x080b8ee0 in entrySplitPage ()
#1 0x080baccf in ginInsertValue ()
#2 0x080b81b7 in gin_xlog_cleanup ()
#3 0x080af4ce in StartupXLOG ()
#4 0x080c04ca in BootstrapMain ()
#5 0x08186b2f in StartChildProcess ()
#6 0x081889eb in PostmasterMain ()
#7 0x0814ee9e in main ()
Craig A. McElroy
Beyond Managed Hosting(r) for Your Enterprise
On Oct 24, 2007, at 1:26 PM, Tom Lane wrote:
> 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
> regards, tom lane
> ---------------------------(end of
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> message can get through to the mailing list cleanly
In response to
pgsql-admin by date
|Next:||From: Vishal Arora||Date: 2007-10-25 07:37:12|
|Subject: Postgres SQL Client for Suse Linux|
|Previous:||From: Tom Lane||Date: 2007-10-25 04:51:20|
|Subject: Re: l need help |