Re: PostgreSQL File System Based Backup Restartability - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: PostgreSQL File System Based Backup Restartability
Date
Msg-id 439854218.872886.1424290612172.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to Re: PostgreSQL File System Based Backup Restartability  (girish R G peetle <giri.anamika0@gmail.com>)
List pgsql-admin
girish R G peetle <giri.anamika0@gmail.com> wrote:

> What if a file that got partially copied disappears (say it
> belonged to a table n table was dropped ) when I resume backup.
> Should I mark this partially copied file invalid in backup media ?

It doesn't much matter.  WAL replay will delete the file if found,
and must tolerate a missing file.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: PostgreSQL File System Based Backup Restartability
Next
From: Drazen Kacar
Date:
Subject: Query cancellation on hot standby because of buffer pins