On Thursday 28 August 2008, Shane Ambler <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
