Re: Point in Time Recovery - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Point in Time Recovery
Date
Msg-id 20120.1089985039@sss.pgh.pa.us
Whole thread Raw
In response to Re: Point in Time Recovery  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Responses Re: Point in Time Recovery
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> We only need to tell people to backup pg_control first. The rest was only 
> intended to enforce 
> 1. that pg_control is the first file backed up
> 2. the dba uses a large enough PIT (or xid) for restore

Right, but I think Bruce's point is that it is far too easy to get those
things wrong; especially point 2 for which a straight tar dump will
simply not contain the information you need to determine what is a safe
stopping point.

I agree with Bruce that we should have some mechanism that doesn't rely
on the DBA to get this right.  Exactly what the mechanism should be is
certainly open for discussion...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: serverlog rotation/functions
Next
From: "Magnus Hagander"
Date:
Subject: Re: [pgsql-hackers-win32] Weird new time zone