Re: Problem with PITR recovery - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Problem with PITR recovery
Date
Msg-id 200504181659.j3IGxs226388@candle.pha.pa.us
Whole thread Raw
In response to Re: Problem with PITR recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Problem with PITR recovery
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Ragnar Hafsta� wrote:
> >> On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
> >>> I am not clear on what the "backup dump file" is?  I assume it means
> >>> 0000000100001234000055CD.  It is called "WAL segment file" above.  I
> >>> will rename that phrase to match the above terminology.  Patch attached
> >>> and applied.
> >> 
> >> Doesn't it refer to the backup file itself (the tar file of the data
> >> directory) ?
> 
> > No.  That is what I thought it meant on first reading, but looking
> > closer it is referring to the numbered file, and the tar file has no
> > specific number.
> 
> Yes, that is exactly what it meant, and your patch has destroyed the
> meaning.

The sentence was:
Once you have safely archived the backup dump file, you can delete allarchived WAL segments with names numerically
precedingthis one.
 

so you were saying:
Once you have safely archived the file system backup, you can delete allarchived WAL segments with names numerically
precedingthis one.
 

I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the file
system badckup to do the recovery.  Do you have new suggested text?

The current text version is in CVS.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Problem with PITR recovery
Next
From: Bruce Momjian
Date:
Subject: Re: SortMem...