On Nov 12, 2007, at 11:07 PM, Greg Smith wrote:
On Mon, 12 Nov 2007, Mason Hale wrote:After the wal segment file is copied by the restore_command script, is it safe to delete it from my archive?While I believe you can toss them immediately, you should considering keeping those around for a bit regardless as an additional layer of disaster recovery resources. I try to avoid deleting them until a new base backup is made, because if you have the last backup and all the archived segments it gives you another potential way to rebuild the database in case of a large disaster damages both the primary and the secondary. You can never have too many ways to try and recover from such a situation.
Plus, the new resumable recovery probably won't be happy if you're too aggressive about nuking WAL logs from the archive.
-- Decibel!, aka Jim C. Nasby, Database Architect decibel@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828
<<attachment: smime.p7s>>
