From: Jesper Krogh <jesper@krogh.cc>
To: pgsql-admin@postgresql.org
Subject: PITR backup & recovery.
Date: Wed, 30 Jul 2008 20:41:38 +0200
Message-ID: <4890B5E2.7080300@krogh.cc> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jesper@krogh.cc
Subject: Re: PITR backup & recovery.
In-Reply-To: <4890B5E2.7080300@krogh.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox