"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes: > What I think is possible is the following (continuous backup of WAL assumed): > - disable VACUUM > - issue CHECKPOINT "C1" > - backup all files > - reenable VACUUM
> - restore files > - adapt pg_control (checkpoint "C1") > - recover WAL until at least end of backup I do not understand this fixation on "disable VACUUM". What are you thinking that will buy you? AFAICS it would make no difference. > I am not sure about clog, isn't clog logged in xlog ? Right. For the purposes of PITR, clog behaves the same as regular data files. You gotta back it up, but a filesystem copy will be inconsistent until fixed by WAL replay. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html