Re: Problem with PITR recovery

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ragnar Hafstað <gnari(at)simnet(dot)is>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problem with PITR recovery
Date: 2005-04-18 16:59:54
Message-ID: 200504181659.j3IGxs226388@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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 all
archived WAL segments with names numerically preceding this one.

so you were saying:

Once you have safely archived the file system backup, you can delete all
archived WAL segments with names numerically preceding this 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-04-18 17:02:18 Re: SortMem...
Previous Message Bruce Momjian 2005-04-18 16:52:10 Re: Problem with PITR recovery