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

Amit Kapila wrote:
> On Tue, Jul 12, 2016 at 2:02 PM, <harukat(at)sraoss(dot)co(dot)jp> wrote:

> > C:\Program Files\PostgreSQL\9.6\data\base\16393>dir /q 16444
> >
> > C:\Program Files\PostgreSQL\9.6\data\base\16393 directory
> >
> > 2016/07/12 15:56 0 ... 16444
> >
> > Dir command says the file 16444's owner is '...'.
> > It means file 16444 is in STATUS_DELETE_PENDING.

> pg_basebackup tries to backup all the files in data directory and
> tablespaces. Refer Notes section of pg_basebackup documentation. I
> think if it decides to skip a file with some bad status, it might also
> lead to a corrupt backup. I wonder how the file has such a status?
> From the name, it looks to be a valid database file.

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.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services