> Can I just grab the latest WAL in use WAL file and rsync it off
> somewhere so that when I need to do a PITR restore, I have it
> available to put back into the pg_xlog directory such that I don't
> lose too much data? The DB I'm looking at using PITR for restores
> only rolls over WAL files about once every 5-6 hours and that seems
> like quite a bit of time to lose if we need to do a restore.
If you WAL log turnover is that low, you should consider periodically
using CHECKPOINT instead of PITR.
http://developer.postgresql.org/docs/postgres/sql-checkpoint.html
-sc
--
Sean Chittenden