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 46C15C39FEB2C44BA555E356FBCD6FA4961E15@m0114.s-mxs.net
Whole thread Raw
In response to Issues Outstanding for Point In Time Recovery (PITR)  ("J. R. Nield" <jrnield@usol.com>)
List pgsql-hackers
> As noted, one of the main problems is knowing where to begin
> in the log.  This can be handled by having backup processing
> update the control file with the first lsn and log file
> required.  At the time of the backup, this information is or
> can be made available.  The control file can be the last file
> added to the tar and can contain information spanning the entire
> backup process.

lsn and logfile number (of latest checkpoints) is already in the control
file, thus you need control file at start of backup. (To reduce the number
of logs needed for restore of an online backup you could force a checkpoint
before starting file backup)

You will also need lsn and logfile number after file backup, to know how much
log needs to at least be replayed to regain a consistent state.

Andreas




pgsql-hackers by date:

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