"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> Yes. But I think you might have to avoid "vacuum full" during data file backup.
Why? If vacuum is unsafe in this scenario, wouldn't it also be unsafe
in event of a system crash?
I do believe that vacuum should (but presently does not) emit a WAL
record showing its truncation of the file, so that the equivalent
truncation can be repeated during replay. However, this is needed
in any case --- point-in-time recovery simply means replaying WAL on
a slightly longer timescale than is usual for crash-recovery.
> And you need the whole WAL including the "page images".
Check, you can't compress out the page images.
regards, tom lane