Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8D0D82E0117 for ; Sun, 25 Nov 2007 11:33:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 92524-03 for ; Sun, 25 Nov 2007 11:33:06 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.239]) by postgresql.org (Postfix) with ESMTP id D14FA2E0073 for ; Sun, 25 Nov 2007 11:33:12 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so112449nzf for ; Sun, 25 Nov 2007 07:33:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=Hg+esqd7PF8JNKwEdeJU7Tcf/HaO2PUcjwhwY2Yf6NY=; b=jSirNaVzlWlcPjyVZ7ysqJmnSz2sc/OZHP1LBmEvbnHx5vHN/KLSs/Jtc0CpkpQcpLLOIDkU9aSiucvhAtY1GXqmuiZkbFawFxShTdA5pl/j5jq2wXZzzZFXTJr9J0pxzRHqFZUakGIWNBmCnJRHDrrhWAoDigAxQlnQw3JJxf0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZZXDW6gi+WexoGtMMl9ioI2H62CLZilDTnokDWmrx7nNYrwbHJoG8aMY1bdDe0CxNaA6DpUj8i6l/z9TRASh/zc0BqBaVVx0U9DyU409igoSfyI9GdAQggRCf39vh0YhzH+fEwPgGlWAEHJ697FD5j2JArJYCSsMmnL9cr3+Xyw= Received: by 10.142.97.20 with SMTP id u20mr135911wfb.1196004790836; Sun, 25 Nov 2007 07:33:10 -0800 (PST) Received: by 10.142.232.20 with HTTP; Sun, 25 Nov 2007 07:33:10 -0800 (PST) Message-ID: Date: Sun, 25 Nov 2007 09:33:10 -0600 From: "Jeff Larsen" To: pgsql-admin@postgresql.org Subject: Re: pg_start_backup without WAL archiving In-Reply-To: <200711251524.08249.peter_e@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200711251524.08249.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/211 X-Sequence-Number: 27454 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.