Postgres Pro
Downloads
Home   >   mailing lists

Re: Continuous archiving and wal generation - Mailing list pgsql-admin

From Mikko Partio
Subject Re: Continuous archiving and wal generation
Date
Msg-id 2ca799770710210515u535d3c4bs2df98e344a499554@mail.gmail.com
Whole thread Raw
In response to Re: Continuous archiving and wal generation  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view


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


pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Cluster/Replication
Next
From: yogesh
Date:
Subject: Re: Trigger AFTER UPDATE OR INSERT