On Thursday 28 August 2008, Shane Ambler <pgsql@xxxxxxxxxx> wrote: > If you have a filesystem backup from 6 hours ago, then the WAL files as > they are now can be used to update the backup to match the db as it is > now. This makes the filesystem backup have two points of interest. First > the entire data folder. Second the WAL files. You may backup the entire > data folder maybe once a day (or week?) but you would also want to backup > the WAL files maybe every 15 mins. No, no. Completed WAL files will be archived automatically as part of the PITR backup strategy. Just backing up WAL files from pg_xlog isn't useful. The files get overwritten constantly. -- Alan
