Re: [HACKERS] Point in Time Recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Klaus Naumann <kn(at)mgnet(dot)de>, markw(at)osdl(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [HACKERS] Point in Time Recovery
Date: 2004-07-14 13:20:08
Message-ID: 25903.1089811208@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-patches

Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> I've not done power off tests, yet. They need to be done just to
> check...actually you don't need to do this to test PITR...

I agree, power off is not really the point here. What we need to check
into is (a) the mechanics of archiving WAL segments and (b) the
process of restoring given a backup and a bunch of WAL segments.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Wabner 2004-07-14 13:27:36 shutdown postgres under windows
Previous Message Claudia Dantas Procopio 2004-07-14 12:04:16 Help - Error in createdb

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2004-07-14 15:04:02 Re: serverlog rotation/functions
Previous Message Zeugswetter Andreas SB SD 2004-07-14 09:57:17 Re: Point in Time Recovery

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-07-14 13:35:55 Re: serverlog rotation/functions
Previous Message Oliver Elphick 2004-07-14 08:41:46 Re: [HACKERS] Is "trust" really a good default?