X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 45159537A3 for ; Fri, 1 Apr 2005 07:31:12 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93930-04 for ; Fri, 1 Apr 2005 06:31:02 +0000 (GMT) Received: from cmailg4.svr.pol.co.uk (cmailg4.svr.pol.co.uk [195.92.195.174]) by svr1.postgresql.org (Postfix) with ESMTP id 6C2E15375B for ; Fri, 1 Apr 2005 07:31:01 +0100 (BST) Received: from modem-3957.llama.dialup.pol.co.uk ([217.135.191.117] helo=192.168.0.102) by cmailg4.svr.pol.co.uk with esmtp (Exim 4.41) id 1DHFgL-00079n-5r; Fri, 01 Apr 2005 07:31:01 +0100 Subject: Re: Online Backups with 8.0 -- Confused From: Simon Riggs To: Jason DiCioccio Cc: pgsql-admin@postgresql.org In-Reply-To: <89bc2a040503312046558f48a9@mail.gmail.com> References: <89bc2a0405033115412175ce96@mail.gmail.com> <1112315398.16721.562.camel@localhost.localdomain> <89bc2a040503312046558f48a9@mail.gmail.com> Content-Type: text/plain Organization: 2nd Quadrant Date: Fri, 01 Apr 2005 07:29:24 +0100 Message-Id: <1112336965.16721.585.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.048 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/6 X-Sequence-Number: 17019 On Thu, 2005-03-31 at 23:46 -0500, Jason DiCioccio wrote: > Simon, > > On Mar 31, 2005 7:29 PM, Simon Riggs wrote: > > > > 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