ok, will do that , thx for your help ;)
Pierre-Yves Landuré
Le jeu 08/08/2002 à 08:45, Tom Lane a écrit :
> Pierre-Yves LANDURE <pylandur@ifremer.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster