Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5E6C02E00FF for ; Sun, 25 Nov 2007 12:04:27 -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 27263-01 for ; Sun, 25 Nov 2007 12:04:27 -0400 (AST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 76C292E00FD for ; Sun, 25 Nov 2007 12:04:26 -0400 (AST) Received: (qmail invoked by alias); 25 Nov 2007 16:04:25 -0000 Received: from xdsl-87-79-143-46.netcologne.de (EHLO colt.pezone.net) [87.79.143.46] by mail.gmx.net (mp005) with SMTP; 25 Nov 2007 17:04:25 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/H2mxiPMvHSriUOgiFbjIFknVndCExYbMkmJ47N8 9LGGsnjn3TCsrf From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: pg_start_backup without WAL archiving Date: Sun, 25 Nov 2007 17:04:22 +0100 User-Agent: KMail/1.9.7 Cc: "Jeff Larsen" References: <200711251524.08249.peter_e@gmx.net> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200711251704.23628.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/212 X-Sequence-Number: 27455 Jeff Larsen wrote: > On Nov 25, 2007 8:24 AM, Peter Eisentraut wrote: > > Why is it not allowed to call pg_start_backup when WAL archiving is off? > > Wouldn't this be useful as a discrete file system backup without PITR > > capability? > > 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. -- Peter Eisentraut http://developer.postgresql.org/~petere/