From: Mikko Partio <mpartio@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: Continuous archiving and wal generation
Date: Sun, 21 Oct 2007 15:15:41 +0300
Message-ID: <2ca799770710210515u535d3c4bs2df98e344a499554@mail.gmail.com> (raw)
In-Reply-To: <47187F73.EE98.0025.0@wicourts.gov>
References: <2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com>
<47187F73.EE98.0025.0@wicourts.gov>
On 10/19/07, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
>
> >>> On Fri, Oct 19, 2007 at 1:40 AM, in message
> <2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com>, "Mikko
> Partio"
> <mpartio@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mpartio@gmail.com, Kevin.Grittner@wicourts.gov
Subject: Re: Continuous archiving and wal generation
In-Reply-To: <2ca799770710210515u535d3c4bs2df98e344a499554@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox