Re: PITR and warm standby setup questions

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@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828