Tom Lane wrote:
Andreas Pflug <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
