Thread: pgsql: Fix pg_rewind bugs when rewinding a standby server.
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that portion when determining whether the server needs rewinding. Backpatch to all supported versions. Author: Ian Barwick and me Discussion: https://www.postgresql.org/message-id/CABvVfJU-LDWvoz4-Yow3Ay5LZYTuPD7eSjjE4kGyNZpXC6FrVQ%40mail.gmail.com Branch ------ REL9_6_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0740857de7804609783eb9f11f055776c1fff4e8 Modified Files -------------- src/bin/pg_rewind/parsexlog.c | 11 +- src/bin/pg_rewind/pg_rewind.c | 56 +++++---- src/bin/pg_rewind/t/008_min_recovery_point.pl | 165 ++++++++++++++++++++++++++ 3 files changed, 209 insertions(+), 23 deletions(-)