From: sgm <sgm277@yahoo.com.cn>
To: pgsql-admin@postgresql.org
Subject: Question about PITR backup
Date: Fri, 8 Jun 2012 18:43:34 +0800 (CST)
Message-ID: <1339152214.5566.YahooMailClassic@web15601.mail.cnb.yahoo.com> (raw)
Dear admin,
I have a question about PITR backup in a single server, the method is make a base backup, and backup the WAL archive log(eg, every day at 11:30 pm). But if the OS' harddisk is broken(eg,14:00 pm),the system can't start, we have to recover the database on a another server using the base backup and the WAL backup,so in this case suppose that we only can restore the database to yesterday's 11:30 pm state, am I right?
How can we recover the database to 14:00 pm? We are missing the newest pg_xlog.
I want to backup the pg_xlog folder every minute by crontab but my concern is that the data inconsistent, because the lastest log in pg_xlog is being updated all the time, am I right? Any suggestions?
Very appreciated your answer.
Thanks,
Song
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: sgm277@yahoo.com.cn
Subject: Re: Question about PITR backup
In-Reply-To: <1339152214.5566.YahooMailClassic@web15601.mail.cnb.yahoo.com>
* 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