]> granicus.if.org Git - postgresql/commit
Fix pause_at_recovery_target + recovery_target_inclusive combination.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 8 Jan 2014 21:06:03 +0000 (23:06 +0200)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 8 Jan 2014 21:31:01 +0000 (23:31 +0200)
commit0402f24413c3e70f796562cb5459f33af071b0cc
tree269bcc4b7aed883032eeb3f897b46c34245f1c93
parente56430c620357a3150e84e7fff9cc494031042a5
Fix pause_at_recovery_target + recovery_target_inclusive combination.

If pause_at_recovery_target is set, recovery pauses *before* applying the
target record, even if recovery_target_inclusive is set. If you then
continue with pg_xlog_replay_resume(), it will apply the target record
before ending recovery. In other words, if you log in while it's paused
and verify that the database looks OK, ending recovery changes its state
again, possibly destroying data that you were tring to salvage with PITR.

Backpatch to 9.1, this has been broken since pause_at_recovery_target was
added.
src/backend/access/transam/xlog.c