Re: Vacuum problem in my system ?

No core dump could be found within the data/base/*
directories. The cron is executed by user root,
but on my system root is a PostgreSQL superuser.

Tom Lane wrote:
> 
> Fabrice Scemama <fabrices@ximmo.ftd.fr> writes:
> > [ vacuum appears to be coredumping ]
> 
> That's odd ... not so much that vacuum could be failing, which is
> probably a garden-variety bug; but it sounds like the postmaster is
> failing to do the system restart that it should do after one of the
> backends fails.  Is there anything showing up in the postmaster log
> when this happens?
> 
> As for tracking the immediate vacuum problem, the failed backend
> should have left a core dump file in the database directory
> (.../data/base/DBNAME/core).  Can you get a backtrace from that
> with gdb?  Something like
>         gdb path/to/postgres path/to/core
>         bt
>         quit
> should do.
> 
>                         regards, tom lane