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

From Mark Kirkwood
Subject Re: Point in Time Recovery
Date
Msg-id 4108C496.2030801@coretech.co.nz
Whole thread Raw
In response to Re: Point in Time Recovery  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Point in Time Recovery  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
I was wondering about this point - might it not be just as reasonable 
for the copied file to *be* an exact image of pg_control?  Then a very 
simple variant of pg_controldata (or maybe even just adding switches to 
pg_controldata itself) would enable the relevant info to be extracted

P.s : would love to be that volunteer - however up to the eyeballs in 
Business Objects (cringe) and Db2 for the next week or so....

regards

Mark

Bruce Momjian wrote:

>We need someone to code two backend functions to complete PITR. 
>
>>><snippage>
>>>      
>>>
>>>>However, once you decide to do things like that, there is no reason why
>>>>the copied file has to be an exact image of pg_control.  I claim it
>>>>would be more useful if the copied file were plain text so that you
>>>>could just "cat" it to find out the starting WAL position; that would
>>>>let you determine without any special tools what range of WAL archive
>>>>files you are going to need to bring back from your archives.
>>>>        
>>>>
>>>


pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: more signals (was: Function to kill backend)
Next
From: Gaetano Mendola
Date:
Subject: extra info on autovaccum log