"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

Reply via email to