pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Simon Riggs <simon@2ndQuadrant.com>
To: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
Cc: pgsql-admin@postgresql.org, Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
Subject: Re: Online backups are failing
Date: Wed, 21 Jan 2009 00:02:26 +0000
Message-ID: <1232496146.2327.298.camel@ebony.2ndQuadrant> (raw)
In-Reply-To: <C84662912D280D4AB5C50100A100F0C503F4BB87@ct11exm61.ds.mot.com>
References: <C84662912D280D4AB5C50100A100F0C503F4BB87@ct11exm61.ds.mot.com>


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

view thread (4+ messages)

Message-ID: <1232496146.2327.298.camel@ebony.2ndQuadrant>
Permalink:  ../1232496146.2327.298.camel@ebony.2ndQuadrant/
Also on:    postgresql.org/message-id/1232496146.2327.298.camel@ebony.2ndQuadrant

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: simon@2ndQuadrant.com, PBhella@Motorola.com, SSubbiah@Motorola.com
  Subject: Re: Online backups are failing
  In-Reply-To: <1232496146.2327.298.camel@ebony.2ndQuadrant>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox