X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2C8619DCA43 for ; Thu, 22 Dec 2005 18:17:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66616-02 for ; Thu, 22 Dec 2005 18:17:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 74B079DC837 for ; Thu, 22 Dec 2005 18:17:30 -0400 (AST) Received: from [192.168.0.4] (195-112-43-70.dyn.gotadsl.co.uk [195.112.43.70]) by smtp.nildram.co.uk (Postfix) with ESMTP id CF43E26EFB4; Thu, 22 Dec 2005 22:17:28 +0000 (GMT) Subject: Re: WAL and pg_dump From: Simon Riggs To: Mike C Cc: pgsql-admin@postgresql.org In-Reply-To: References: <1135208028.2964.329.camel@localhost.localdomain> Content-Type: text/plain Date: Thu, 22 Dec 2005 22:17:32 +0000 Message-Id: <1135289852.2964.542.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.09 required=5 tests=[AWL=0.090] X-Spam-Score: 0.09 X-Spam-Level: X-Archive-Number: 200512/280 X-Sequence-Number: 20000 On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote: > On 12/22/05, Simon Riggs wrote: > On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote: > > All the documentation I've seen for PITR points to having to > do a file > > system copy of sorts. > > Yes. There's no other way, but why would you want another way? > > Mainly because a pg_dump backup takes up a lot less disk space than a > filesystem copy (in my case, approx 3.5GB backup from a 25GB db). What is your backup time in each case, and what is your recovery time? Is space your limiting factor? Best Regards, Simon Riggs