pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Mikko Partio <mpartio@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Continuous archiving and wal generation
Date: Fri, 19 Oct 2007 09:57:07 -0500
Message-ID: <47187F73.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com>
References: <2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com>

>>> On Fri, Oct 19, 2007 at  1:40 AM, in message
<2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com>, "Mikko Partio"
<mpartio@gmail.com> wrote: 
> 
> To make use of the backup, you will need to keep around all the WAL segment
> files generated during and after the file system backup. To aid you in doing
> this, the pg_stop_backup function creates a *backup history file* that is
> immediately stored into the WAL archive area. This file is named after the
> first WAL segment file that you need to have to make use of the backup. For
> example, if the starting WAL file is 0000000100001234000055CD the backup
> history file will be named something like
> 0000000100001234000055CD.007C9330.backup.
> 
> My question is: if I have a large database which takes some time to backup
> with tar, and during the interval between pg_start_backup() and
> pg_stop_backup() more than one wal file gets generated, do I have to store
> in addition to the base backup all wal files generated during the backup
> interval or just the one specified by the .backup file?
> 
> 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
 





view thread (3+ messages)  latest in thread

Message-ID: <47187F73.EE98.0025.0@wicourts.gov>
Permalink:  ../47187F73.EE98.0025.0@wicourts.gov/
Also on:    postgresql.org/message-id/47187F73.EE98.0025.0@wicourts.gov

 · 

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: Kevin.Grittner@wicourts.gov, mpartio@gmail.com
  Subject: Re: Continuous archiving and wal generation
  In-Reply-To: <47187F73.EE98.0025.0@wicourts.gov>

* 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