From: Jason DiCioccio <geniusj@gmail.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Online Backups with 8.0 -- Confused
Date: Thu, 31 Mar 2005 23:46:52 -0500
Message-ID: <89bc2a040503312046558f48a9@mail.gmail.com> (raw)
In-Reply-To: <1112315398.16721.562.camel@localhost.localdomain>
References: <89bc2a0405033115412175ce96@mail.gmail.com>
<1112315398.16721.562.camel@localhost.localdomain>
Simon,
On Mar 31, 2005 7:29 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> <snip>
> In retrospect, there is a slight timing error between end backup and
> archival of next WAL log. The first-release design for PITR didn't fully
> cover lower traffic situations, so in those cases the timing error
> becomes noticeable. You're not the first to observe this, though only by
> about a month.
>
> I'm considering options for the next release, since major change seems
> to be required to the basic xlog handling mechanisms.
Thank you very much for the info. Given the situation then, how would
you recommend doing what I'm trying to do? Or what would be a good
method of doing these online backups?
Would doing 1 base backup a day, keeping a couple of days worth, and
backing up the archive logs as the come in be the best way? I guess I
was just trying to do the base and WAL backup at the same time and all
at once, which is probably not what it's designed for, as I'm not
figuring out.
Thanks!
-JD-
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: geniusj@gmail.com, simon@2ndquadrant.com
Subject: Re: Online Backups with 8.0 -- Confused
In-Reply-To: <89bc2a040503312046558f48a9@mail.gmail.com>
References: <89bc2a0405033115412175ce96@mail.gmail.com> <1112315398.16721.562.camel@localhost.localdomain> <89bc2a040503312046558f48a9@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