On 18-Jan-08, at 2:32 PM, Erik Jones wrote:
What worries me is, that since I have a verified case of rsync
thinking it had successfully transferred a WAL, the same may have
happened with these files during the base backup. Does that
warning, in fact, entail that there were catalog entries for those
files, but that the file was not there, and by "fixing" it the
server just created empty files?
We archive WALs directly to an NFS mount. We once had a zero-byte WAL
file archived, which I believe was the result of a temporary issue
with the NFS mount. We had to perform a new base backup since the WAL
was deleted/reused by PG because it was told it was archived
successfully. It sounds similar to the problem you experienced. Do you
rsync to an NFS mount?
If this issue is occurring when archiving WALs, I agree that it could
be occurring when trying to get a base backup.
Brian Wipf
<brian@xxxxxxxxxxxxxx>
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
