Re: WAL file questions - how to relocate on Windows, how to replay after total loss, etc

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL file questions - how to relocate on Windows, how to replay after total loss, etc
Date: 2008-08-28 18:02:49
Message-ID: 200808281102.49554@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Alan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-08-28 18:08:18 Re: strange explain analyze output
Previous Message F. Jovan Jester 2008-08-28 17:54:16 Re: Postgres in a solaris zone