Re: Vacuum problem in my system ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Vacuum problem in my system ?
Date
Msg-id 12539.960221996@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum problem in my system ?  (Fabrice Scemama <fabrices@ximmo.ftd.fr>)
List pgsql-sql
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 likegdb path/to/postgres path/to/corebtquit
should do.
        regards, tom lane


pgsql-sql by date:

Previous
From: Fabrice Scemama
Date:
Subject: Vacuum problem in my system ?
Next
From: "Rob S."
Date:
Subject: RE: Default timestamp value