Tom Lane wrote:
> So, when it archives successfully the second time, which if either of
> the two mismatched sha1's proves to have been correct?
The one on the master server (lines wrapped for readability).
"local" refers to the master server, and "remote" to the standby
Oct 27 14:26:35 colo2vs1 canit-failover-wal-archive: Warning:
rsync succeeded, but local_sha1
remote_sha1 4f9f8bcd151129db64acd05470f0f05954b56232 !!
Oct 27 14:26:52 colo2vs1 canit-failover-wal-archive: local_sha1 ==
Oct 27 14:26:53 colo2vs1 canit-failover-wal-archive:
Successfully archived WAL file 000000010000001200000058 on
However, the sha1 is taken after rsync exits, so it's unknown what
the local sha1 actually was while the rsync was running. Maybe the
sha1 really was 4f9... on the master server until something changed
> (I'm still wondering about the possibility that the WAL file is changing
> underneath you ...)
Well, can PostgreSQL change the WAL file while the archive_command is
running? I can't see anything on the backup server end changing that
In response to
pgsql-admin by date
|Next:||From: Kevin Grittner||Date: 2009-10-27 19:42:17|
|Subject: Re: Warm standby problems: Followup|
|Previous:||From: Tom Lane||Date: 2009-10-27 19:22:20|
|Subject: Re: Warm standby problems: Followup |