Tom Lane wrote:
>Andreas Pflug <pgadmin(at)pse-consulting(dot)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