Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: Amit Kapila <amit.kapila16@gmail.com>, harukat@sraoss.co.jp, PostgreSQL Bugs <pgsql-bugs@postgresql.org>

Date: 2016-07-12T23:05:16Z

Lists: pgsql-bugs

Alvaro Herrera <alvherre@2ndquadrant.com> writes:
>> On Tue, Jul 12, 2016 at 2:02 PM,  <harukat@sraoss.co.jp> wrote:
>>> It means file 16444 is in STATUS_DELETE_PENDING.

> This file is probably being deleted by a checkpoint after some user
> transaction marked it for removal (either because the relation was
> dropped, or because it got a new relfilenode).  I would say that the
> file is not needed for the backup after all and pg_basebackup should
> just ignore it.

Yeah.  The question is how do we distinguish that from cases that
are less benign.

			regards, tom lane