Re: Point in Time Recovery

Ok - that is a much better way of doing it!

regards

Mark

Tom Lane wrote:

>"Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> writes:
>
>
>>If you use a readable file you will also need a feature for restore
>>(or a tool) to create an appropriate pg_control file, or are you
>>intending to still require that pg_control be the first file backed
>>up.
>>
>>
>
>No, the entire point of this exercise is to get rid of that assumption.
>You do need *a* copy of pg_control, but the only reason you'd need to
>back it up first rather than later is so that its checkpoint pointer
>points to the last checkpoint before the dump starts. Which is the
>information we want to put in the archive-label file insted.
>
>If a copy of pg_control were sufficient then I'd be all for using it as
>the archive-label file, but it's *not* sufficient because you also need
>the ending WAL offset. So we need a different file layout in any case,
>and we may as well take some pity on the poor DBA and make the file
>easily human-readable.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>