Re: Continuous archiving and wal generation

On 10/19/07, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>
> >>> On Fri, Oct 19, 2007 at 1:40 AM, in message
> <2ca799770710182340y9877687i8e82cd6847f37c5a(at)mail(dot)gmail(dot)com>, "Mikko
> Partio"
> <mpartio(at)gmail(dot)com> wrote:
> >
> > I'm trying to figure out the minimum required to restore from a backup
>
> If you look inside that backup file, you'll see something like this:
>
> START WAL LOCATION: 47/11B7E980 (file 000000010000004700000011)
> STOP WAL LOCATION: 47/13006410 (file 000000010000004700000013)
> CHECKPOINT LOCATION: 47/11B7E980
> START TIME: 2007-10-12 19:00:02 CDT
> LABEL: 2007-10-12_190002
> STOP TIME: 2007-10-12 20:10:30 CDT
>
> It tells you what files you need, as a minimum, to restore.
>
> -Kevin

Thanks.

Regards

M