Re: pgsql: Fix WAL replay in presence of an incomplete record
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2021-11-05T00:13:50Z
Lists: pgsql-hackers
[ I'm working on the release notes ] Alvaro Herrera <alvherre@alvh.no-ip.org> writes: > Fix WAL replay in presence of an incomplete record > ... > Because a new type of WAL record is added, users should be careful to > upgrade standbys first, primaries later. Otherwise they risk the standby > being unable to start if the primary happens to write such a record. Is there really any point in issuing such advice? IIUC, the standbys would be unable to proceed anyway in case of a primary crash at the wrong time, because an un-updated primary would send them inconsistent WAL. If anything, it seems like it might be marginally better to update the primary first, reducing the window for it to send WAL that the standbys will *never* be able to handle. Then, if it crashes, at least the WAL contains something the standbys can process once you update them. Or am I missing something? regards, tom lane
Commits
-
Repair two portability oversights of new test
- e3731bac52cf 14.1 landed
- d03bca4d70c2 15.0 landed
-
Fix WAL replay in presence of an incomplete record
- ff9f111bce24 15.0 cited
-
Avoid creating archive status ".ready" files too early
- 515e3d84a0b5 15.0 cited