pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (3+ messages)

Message-ID: <2ca799770710210515u535d3c4bs2df98e344a499554@mail.gmail.com>
Permalink:  ../2ca799770710210515u535d3c4bs2df98e344a499554@mail.gmail.com/
Also on:    postgresql.org/message-id/2ca799770710210515u535d3c4bs2df98e344a499554@mail.gmail.com

 · 

reply

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