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 40F2E9DCC56 for ; Wed, 21 Dec 2005 19:33:48 -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 41595-09 for ; Wed, 21 Dec 2005 19:33:50 -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 EEE859DC85D for ; Wed, 21 Dec 2005 19:33:45 -0400 (AST) Received: from [192.168.0.4] (82-133-115-75.dyn.gotadsl.co.uk [82.133.115.75]) by smtp.nildram.co.uk (Postfix) with ESMTP id C88BB26FF9C; Wed, 21 Dec 2005 23:33:44 +0000 (GMT) Subject: Re: WAL and pg_dump From: Simon Riggs To: Mike C Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Wed, 21 Dec 2005 23:33:48 +0000 Message-Id: <1135208028.2964.329.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/259 X-Sequence-Number: 19979 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? > Is it possible to have a weekly pg_dump and restore the database up to > the last archived WAL file if the db server fails? No. pg_dump only copies the data, not the current state of the database. > If so, how? Is it just a matter of restoring the database then copying > the archived WAL files into the xlog dir and creating a recovery.conf > file? Best Regards, Simon Riggs