Ühel kenal päeval, P, 2006-04-16 kell 11:31, kirjutas Tom Lane: > "Marko Kreen" <[EMAIL PROTECTED]> writes: > > So we should probably document that rsync is only working solution. > > No, we're just turning off the variable. One experiment on one version > of rsync doesn't prove it's "safe", even if there weren't the kernel- > behavior issue to consider.
But if we do need to consider the kernel-level behaviour mentioned, then the whole PITR thing becomes an impossibility. Consider the case when we get a torn page during the initial copy with tar/cpio/rsync/whatever, and no WAL record updates it. In that case we will just have a torn page in backup with no way to fix it. ------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly