Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group