pgsql: Check if we've reached end-of-backup point also if no redo is re - Mailing list pgsql-committers

From Heikki Linnakangas
Subject pgsql: Check if we've reached end-of-backup point also if no redo is re
Date
Msg-id E1TlIfK-00043A-7Y@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Check if we've reached end-of-backup point also if no redo is required.

If you restored from a backup taken from a standby, and the last record in
the backup is the checkpoint record, ie. there is no redo required except
for the checkpoint record, we would fail to notice that we've reached the
end-of-backup point, and the database is consistent. The result was an
error "WAL ends before end of online backup". To fix, move the
have-we-reached-end-of-backup check into CheckRecoveryConsistency(), which
is already responsible for similar checks with minRecoveryPoint, and is
called in the right places.

Backpatch to 9.2, this check and bug did not exist before that.

Branch
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/8e1e8278c35be9b70e92c8b43a8f65b372dc269a

Modified Files
--------------
src/backend/access/transam/xlog.c |   49 +++++++++++++++++++++----------------
1 files changed, 28 insertions(+), 21 deletions(-)


pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Check if we've reached end-of-backup point also if no redo is re
Next
From: Bruce Momjian
Date:
Subject: pgsql: Add pg_upgrade comment about mismatch error