Online backups are failing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


Thanks
Paramjeet Bhella
 

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux