Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DAE78632501 for ; Tue, 20 Jan 2009 20:01:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88326-05 for ; Tue, 20 Jan 2009 20:01:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137173.authsmtp.com (outmail137173.authsmtp.com [62.13.137.173]) by mail.postgresql.org (Postfix) with ESMTP id 1DF5D6322B7 for ; Tue, 20 Jan 2009 20:00:36 -0400 (AST) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n0L00Vsd090053; Wed, 21 Jan 2009 00:00:31 GMT Received: from [192.168.0.3] (85-211-98-195.dyn.gotadsl.co.uk [85.211.98.195]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n0L00UZm073024; Wed, 21 Jan 2009 00:00:30 GMT Subject: Re: Online backups are failing From: Simon Riggs To: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@postgresql.org, Subbiah Stalin-XCGF84 In-Reply-To: References: Content-Type: text/plain Date: Wed, 21 Jan 2009 00:02:26 +0000 Message-Id: <1232496146.2327.298.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 84715cd0-e74e-11dd-8a51-002264978518 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFagRbZ1hf HGQLW11EUF17WWN/ aAofZQBDYEtPQQxi TklAR01QEQdtHhxP WB5iUhkXHVhGf31w Z0IsX3FYXApycUF8 Rx0AFXBTYmM1dWEe BBRFf1JRcR5Kfh1H bFR2U3sIYG1JBC9q VzwaExUQGwAXDyJR QwcAZVgbSkUWBiV0 TgoPVTsmHEkEQSpb X-Authentic-SMTP: 61633235383639.pelican.dmpriest.net.uk:1378/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-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/75 X-Sequence-Number: 31122 On Tue, 2009-01-20 at 14:21 -0500, Bhella Paramjeet-PFCW67 wrote: > First we saw this problem on our postgres 8.2.7 database where we had > the "stats_block_level" parameter turned on in postgresql.conf file. > After I turned off stats_block_level parameter, our backups did not > fail. Seems like the stats files are changing while being copied. I'd suggest excluding global/pgstat* from the backup. Stats are reset at recovery anyway, so you've lost nothing. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support