DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.cn;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type;
	b=aFMqaf6T226QLGIxky/1Mu7YrhS74Vd/fUnRJSfuaWG5fgPLkOqSHK/McZGmmUKxPO8Z2NIIkvyHp8B85v1sgJoo/9lr1eILBMa6van9f4TQQQ+P3mLb8kN8xiCyVPp+bXPh/5cGYBLxuAtZX4nvinYXP5+L156jNWWltyZPlrA=;
Message-ID: <1339152214.5566.YahooMailClassic@web15601.mail.cnb.yahoo.com>
Date: Fri, 8 Jun 2012 18:43:34 +0800 (CST)
From: sgm <sgm277@yahoo.com.cn>
Subject: Question about PITR backup
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="940083559-295342153-1339152214=:5566"

--940083559-295342153-1339152214=:5566
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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). B=
ut if the OS' harddisk is broken(eg,14:00 pm),the system can't start, we ha=
ve to recover the database on a another server using the base backup and th=
e WAL backup,so in this case suppose that we only can restore the database =
to yesterday's 11:30 pm state, am I right?=A0
How can we recover the database to 14:00 pm? We are missing the newest pg_x=
log.
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? =A0 Any suggestions?
Very appreciated your answer.
Thanks,
Song=A0
--940083559-295342153-1339152214=:5566
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Dear admin,<div><br></div><div>I have a quest=
ion 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,s=
o in this case suppose that we only can restore the database to yesterday's=
 11:30 pm state, am I right?&nbsp;</div><div><br></div><div>How can we reco=
ver the database to 14:00 pm? We are missing the newest pg_xlog.</div><div>=
<br></div><div>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? &nbsp; Any suggestions?</d=
iv><div><br></div><div>Very appreciated your
 answer.</div><div><br></div><div>Thanks,</div><div><br></div><div>Song&nbs=
p;</div></td></tr></table>
--940083559-295342153-1339152214=:5566--