Re: possible bug: orphaned files left after immediate shutdown during DDL - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: possible bug: orphaned files left after immediate shutdown during DDL
Date
Msg-id 201102161345.p1GDjoO22162@momjian.us
Whole thread Raw
In response to Re: possible bug: orphaned files left after immediate shutdown during DDL  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-bugs
Jeff Davis wrote:
> On Wed, 2011-02-09 at 22:58 -0500, Tom Lane wrote:
> > It's intentional ... not that other people haven't complained about it
> > before.  Remember that what you have done is forced a crash, and
> > recovery from it is crash recovery.  If we proactively removed such
> > files we would very possibly be destroying evidence of forensic value.
>
> I thought that might be the case, but I wasn't able to find any previous
> discussions.
>
> It might be a good idea to issue a warning during recovery, however,
> like "possible orphaned file ...". I'm not sure if it's worth the
> bookkeeping effort though.

I thought we had a TODO item about removing orphaned files, but I don't
see it now, perhaps because I thought we had fixed that.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-bugs by date:

Previous
From: "Konrad Garus"
Date:
Subject: BUG #5889: "Intersects" for polygons broken
Next
From: Tom Lane
Date:
Subject: Re: BUG #5889: "Intersects" for polygons broken