Report WAL flush, not insert, position in replication IDENTIFY_SYSTEM

Heikki Linnakangas <heikki.linnakangas@iki.fi>

Commit: 5f0ba4abb33640205f38e5bee1e981da25175acf
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2015-02-06T09:32:16Z
Releases: 9.3.7
Report WAL flush, not insert, position in replication IDENTIFY_SYSTEM

When beginning streaming replication, the client usually issues the
IDENTIFY_SYSTEM command, which used to return the current WAL insert
position. That's not suitable for the intended purpose of that field,
however. pg_receivexlog uses it to start replication from the reported
point, but if it hasn't been flushed to disk yet, it will fail. Change
IDENTIFY_SYSTEM to report the flush position instead.

Backpatch to 9.1 and above. 9.0 doesn't report any WAL position.

Files

PathChange+/−
doc/src/sgml/protocol.sgml modified +1 −1
src/backend/replication/walsender.c modified +1 −1