-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/01/07 18:04, Glen Parker wrote: >> Tarring hot database files still gives me the willies. But then, I >> wear belt and suspenders. > > I understand. A list of "file changed while we read it" errors is just > a little unnerving at first! > > I did quite a few end to end backup/PITR tests, and no matter what I did > to the DB during backup, no matter how many errors tar or cpio produced, > I have been unable to find any problems with the end result. > > OTOH, I still take a full base backup every night and keep ten days > worth of WAL files on our backup server, so I guess maybe I don't > *completely* trust it :-) Or you don't trust tape to be 100% reliable. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFwpWNS9HxQb37XmcRAtUhAKDavPVEGP4UiqNh8Wn4yM87+8YwGgCeJ0XM QMLq3wgjA1LiVTi+a8xwkI0= =xVi1 -----END PGP SIGNATURE-----
