• Heikki Linnakangas's avatar
    Change the order that pg_xlog and WAL archive are polled for WAL segments. · 4d894b41
    Heikki Linnakangas authored
    If there is a WAL segment with same ID but different TLI present in both
    the WAL archive and pg_xlog, prefer the one with higher TLI. Before this
    patch, the archive was polled first, for all expected TLIs, and only if no
    file was found was pg_xlog scanned. This was a change in behavior from 9.3,
    which first scanned archive and pg_xlog for the highest TLI, then archive
    and pg_xlog for the next highest TLI and so forth. This patch reverts the
    behavior back to what it was in 9.2.
    
    The reason for this is that if for example you try to do archive recovery
    to timeline 2, which branched off timeline 1, but the WAL for timeline 2 is
    not archived yet, we would replay past the timeline switch point on
    timeline 1 using the archived files, before even looking timeline 2's files
    in pg_xlog
    
    Report and patch by Kyotaro Horiguchi. Backpatch to 9.3 where the behavior
    was changed.
    4d894b41
xlog.c 350 KB