Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E15092E0265 for ; Sun, 25 Nov 2007 14:03:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 83892-07 for ; Sun, 25 Nov 2007 14:02:58 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 70AA12E01D4 for ; Sun, 25 Nov 2007 14:02:59 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lAPI2uY2018383; Sun, 25 Nov 2007 13:02:56 -0500 (EST) To: Peter Eisentraut cc: pgsql-admin@postgresql.org, "Jeff Larsen" Subject: Re: pg_start_backup without WAL archiving In-reply-to: <200711251704.23628.peter_e@gmx.net> References: <200711251524.08249.peter_e@gmx.net> <200711251704.23628.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Sun, 25 Nov 2007 17:04:22 +0100" Date: Sun, 25 Nov 2007 13:02:56 -0500 Message-ID: <18382.1196013776@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/214 X-Sequence-Number: 27457 Peter Eisentraut writes: > Jeff Larsen wrote: >> Because a file system level backup is no good unless the database is >> stopped, or you are using PITR. > You are begging the question. If I enable WAL archiving, make a base backup > to a safe place, and my data center goes up in flame immediately afterwards > without a WAL segment being archived, that base backup should still be > usable. Or maybe not. That's the question. And the answer is still "no". If you don't have the entire series of WAL files made over the period of the base backup, you're out of luck. regards, tom lane