Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A06002E0164 for ; Mon, 26 Nov 2007 04:20:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07764-06 for ; Mon, 26 Nov 2007 04:20:03 -0400 (AST) Received: from outmail128150.authsmtp.com (outmail128150.authsmtp.com [62.13.128.150]) by postgresql.org (Postfix) with ESMTP id A11942E016A for ; Mon, 26 Nov 2007 04:20:03 -0400 (AST) Received: from outmail128180.authsmtp.com (outmail128180.authsmtp.com [62.13.128.180]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id lAQ8K2xm041204; Mon, 26 Nov 2007 08:20:02 GMT Received: from [192.168.0.3] (85-211-24-246.dyn.gotadsl.co.uk [85.211.24.246]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id lAQ8K1xZ080719; Mon, 26 Nov 2007 08:20:01 GMT Subject: Re: pg_start_backup without WAL archiving From: Simon Riggs To: Peter Eisentraut Cc: pgsql-admin@postgresql.org In-Reply-To: <200711251524.08249.peter_e@gmx.net> References: <200711251524.08249.peter_e@gmx.net> Content-Type: text/plain Date: Mon, 26 Nov 2007 08:20:20 +0000 Message-Id: <1196065220.4246.635.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 6221a544-9bf8-11dc-814e-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagNbY1ZH HGQLW1NEUFV7W2N/ awsfZQBDYEtPQQdu TkpNRE1QERpoT0Bw ZxZlU1EYdw1Gf395 K05mWT5dXkZ7JEN5 RlNdRzsOeGZhPDMC WEFcIh5UcAJLdhoR aVd4ByJDAzANdhER MyoSGQV5JTpoMzhc WB06J1sZQlsTViE9 WxAFAClnImQhDywp JBwnNF8aEy42 X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/218 X-Sequence-Number: 27461 On Sun, 2007-11-25 at 15:24 +0100, 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? I'm submitting a patch today that better describes PITR facilities for making a standalone backup. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com