Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 897872E0BA5; Thu, 31 Jan 2008 09:28:22 -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 78910-01-6; Thu, 31 Jan 2008 09:28:15 -0400 (AST) Received: from outmail128167.authsmtp.co.uk (outmail128167.authsmtp.co.uk [62.13.128.167]) by postgresql.org (Postfix) with ESMTP id B46BA2E02FF; Thu, 31 Jan 2008 09:28:08 -0400 (AST) Received: from outmail128177.authsmtp.com (outmail128177.authsmtp.com [62.13.128.177]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m0VDS2T9014926; Thu, 31 Jan 2008 13:28:02 GMT Received: from [192.168.0.3] (85-211-31-42.dyn.gotadsl.co.uk [85.211.31.42]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m0VDS1hn056908; Thu, 31 Jan 2008 13:28:01 GMT Subject: Re: [GENERAL] Backup From: Simon Riggs To: Chander Ganesan Cc: Phillip Smith , "'Dominic Carlucci'" , pgsql-general@postgresql.org, pgsql-admin@postgresql.org, carlucci@cae.ca In-Reply-To: <47A1BD51.3030902@otg-nc.com> References: <00a201c85ee9$fbd1ca00$9b0014ac@wbaus090> <1201252875.4257.387.camel@ebony.site> <47A1BD51.3030902@otg-nc.com> Content-Type: text/plain Date: Thu, 31 Jan 2008 13:28:48 +0000 Message-Id: <1201786128.4453.287.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 58ce0cdd-d000-11dc-9554-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacBtFawRbZ1hf HGQLW1xEUV57W2t/ awgfZQBDYEtPQQZr TkxLXVBXCwUmXBxn cn0fCkdycgNPeHY+ ZEdjWT5eVBcvdRUp FlMAFW0GeGZhPDMC WUVdcx5UcAJLdhoR aVd4ByJDAzANdhEX MikeBRkVCH1sAQhw Yyc4ZXgbSkUWBlZp X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:787/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: 200801/291 X-Sequence-Number: 28065 On Thu, 2008-01-31 at 07:21 -0500, Chander Ganesan wrote: > If you don't mind if you lose some transactions That sentence has no place in any discussion about "backup" because the risk is not just a few transactions, it is a corrupt and inconsistent database from which both old and new data would be inaccessible. As far as I am concerned, if any Postgres user loses data then we're all responsible. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com