Re: Issues Outstanding for Point In Time Recovery (PITR) - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Issues Outstanding for Point In Time Recovery (PITR)
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961E14@m0114.s-mxs.net
Whole thread Raw
In response to Issues Outstanding for Point In Time Recovery (PITR)  ("J. R. Nield" <jrnield@usol.com>)
Responses Re: Issues Outstanding for Point In Time Recovery (PITR)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> OK, so you do a tar backup of a file.  While you are doing the tar,
> certain 8k blocks are being modified in the file.  There is no way to
> know what blocks are modified as you are doing the tar, and in fact you
> could read partial page writes during the tar.

No, I think all OS's (Unix and NT at least) guard against this, as long as
the whole 8k block is written in one call. It is only the physical layer (disk)
that is prone to partial writes.

> any page that was modified while we were backing up is in the WAL.  On
> restore, we can recover whatever tar saw of the file, knowing that the
> WAL page images will recover any page changes made during the tar.

Assuming above, I do not think this is necessary.

> What I suggest is a way for the backup tar to turn on pre-change page
> images while the tar is happening, and turn it off after the tar is
> done.

Again, I do not think this is necessary.

Andreas




pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: Proposal: CREATE CONVERSION
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Issues Outstanding for Point In Time Recovery (PITR)