Re: Online backups are failing

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(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997