Re: Online backups are failing - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Online backups are failing
Date
Msg-id 1232480728.16680.33.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Online backups are failing  ("Bhella Paramjeet-PFCW67" <PBhella@Motorola.com>)
List pgsql-admin
On Tue, 2009-01-20 at 14:21 -0500, Bhella Paramjeet-PFCW67 wrote:
> Hi,
>
> We are running into a problem where our online backups are failing
> randomly. We are using postgres 8.2.7 and we are seeing this problem in
> both Solaris and Linux platforms. Our online backup script copies the
> PGDATA dir with the command "cp -r -P".
>
> 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.
>
> Now we are seeing the problem of our online backups failing on our other
> databases which are on postgres 8.2.7 and 8.1.13 and on these DB's the
> stats_block_level parameter is turned off.
>
> Has anyone else run into this problem? Any suggestions on how to resolve
> this problem will be highly appreciated.

We need more information on what your script is actually doing. Are you
calling pg_start_backup before you do the cp? (also you really should
use rsync).

Joshua D. Drake


>
>
> Thanks
> Paramjeet Bhella
>
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


pgsql-admin by date:

Previous
From: "Bhella Paramjeet-PFCW67"
Date:
Subject: Online backups are failing
Next
From: "Bhella Paramjeet-PFCW67"
Date:
Subject: Re: Online backups are failing