"David F. Skoll" <dfs@xxxxxxxxxxxxxxxxxx> writes: > 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). > However, the sha1 is taken after rsync exits, so it's unknown what > the local sha1 actually was while the rsync was running. Be worth taking the sha1 first to see if you get a different answer about that, or maybe even doing it twice. >> (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? It's not supposed to... regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
