pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mikko Partio <mpartio@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Continuous archiving and wal generation
Date: Fri, 19 Oct 2007 09:40:07 +0300
Message-ID: <2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com> (raw)

Hello list

I have a question concerning the continuous archiving process. The manual
says:

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, and
my common sense says that I should archive all the wal files produced during
the backup since they contain information of the data file changes made
during the backup.

Regards

M

view thread (3+ messages)  latest in thread

Message-ID: <2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com>
Permalink:  ../2ca799770710182340y9877687i8e82cd6847f37c5a@mail.gmail.com/
Also on:    postgresql.org/message-id/2ca799770710182340y9877687i8e82cd6847f37c5a@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
  Subject: Re: Continuous archiving and wal generation
  In-Reply-To: <2ca799770710182340y9877687i8e82cd6847f37c5a@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