Bruce, * Bruce Momjian (br...@momjian.us) wrote: > If two writes happens in the middle of a file in the same second, it > seems one might be missed. Yes, I suppose the WAL does fix that during > replay, though if both servers were shut down cleanly, WAL would not be > replayed. > > If you using it for a hot backup, and WAL would clean that up.
Right... If it's hot backup, then WAL will fix it; if it's done after a
clean shut-down, nothing should be writing to those files (much less
multiple writes in the same second), so checksum shouldn't be
necessary...
If you're doing rsync w/o doing pg_start_backup/pg_stop_backup, that's
not likely to work even *with* --checksum..
So, can you explain which case you're specifically worried about?
Thanks,
Stephen
signature.asc
Description: Digital signature
