On Thursday 28 August 2008, Shane Ambler <pgsql(at)sheeky(dot)biz> 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.
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2008-08-28 18:08:18|
|Subject: Re: strange explain analyze output |
|Previous:||From: F. Jovan Jester||Date: 2008-08-28 17:54:16|
|Subject: Re: Postgres in a solaris zone|