"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Mon, 2006-10-23 at 13:52 -0400, Tom Lane wrote: >> No can do --- we rely on the checksums to be able to tell when we've hit >> the end of WAL during replay.
> No we don't: Zero length records are the trigger for EOF. Only if the file happens to be all-zero already, which is not the normal operating state (see WAL-file recycling). Otherwise you have to be able to detect an invalid record. There are actually three checks used to detect end of WAL: zero record length, invalid checksum, and incorrect back-pointer. Zero length is the first and cleanest-looking test, but AFAICS we have to have both of the others to avoid obvious failure modes. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster