Message-ID: <4890B5E2.7080300@krogh.cc>
Date: Wed, 30 Jul 2008 20:41:38 +0200
From: Jesper Krogh <jesper@krogh.cc>
User-Agent: Thunderbird 2.0.0.14 (X11/20080502)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: PITR backup & recovery. 
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi.

I have read the manual chapter over a couple of times. I've even done a
restore of my database and that worked fine. But I'd like to have 
confirmed that it seems correct, so it didn't just work because I didn't 
have any real activity on the database in my test-setup.

I have a Before Backup script that does a:

select pg_start_backup("label");

And ad After Backup script that does a:

select pg_stop_backup();

The backup just takes "everything", meaning both WAL-files and data 
catalog. Runs daily incremental.

After pg_stop_backup() i do a

find /path/to/walarchive/ -type f -ctime 1 | xargs rm -rf

The data catalog is quite big..~200GB thus the inital backup of that
will take quite some time. So if there has been activity in the database
over this amount of time will it still be possible to bring the db to a 
concistent state using the WAL-files?

Thanks.
-- 
Jesper