Re: PITR Functional Design v2 for 7.5

Tom Lane wrote:

>Andreas Pflug <pgadmin@pse-consulting.de> writes:
>  
>
>>To clarify:
>>I'd expect a cluster to be workable, if I
>>- disable VACUUM until backup completed
>>- issue CHECKPOINT
>>- backup clog (CHECKPOINT and backup clog are the "backup checkpoint")
>>- backup all datafiles (which include at least all completed transaction 
>>data at checkpoint time)
>>and then
>>- restore datafiles and clog
>>- bring up pgsql.
>>    
>>
>
>Why is that a useful approach?  You might as well shut down the
>postmaster and do a cold filesystem backup, 
>
We're talking about *hot* backup, aren't we?

Regards,
Andreas