From: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
---|---|
To: | "Patrick Macdonald" <patrickm(at)redhat(dot)com>, "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com> |
Cc: | "PostgreSQL Hacker" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Issues Outstanding for Point In Time Recovery (PITR) |
Date: | 2002-07-08 12:51:04 |
Message-ID: | 46C15C39FEB2C44BA555E356FBCD6FA4961E15@m0114.s-mxs.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2002-07-08 12:59:44 | Re: Proposal: CREATE CONVERSION |
Previous Message | Vince Vielhaber | 2002-07-08 12:22:02 | Re: I am being interviewed by OReilly |