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@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
