Re: Online Backups with 8.0 -- Confused

On Thu, 2005-03-31 at 23:46 -0500, Jason DiCioccio wrote:
> Simon,
>
> On Mar 31, 2005 7:29 PM, Simon Riggs <simon(at)2ndquadrant(dot)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?

Sounds good. Many sites keep more than a couple of copies: last 3 days,
last week and last month.

Best Regards, Simon Riggs