pgsql: Report WAL flush, not insert, position in replication IDENTIFY_S - Mailing list pgsql-committers

From Heikki Linnakangas
Subject pgsql: Report WAL flush, not insert, position in replication IDENTIFY_S
Date
Msg-id E1YJfHy-0001wP-Di@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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.

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/5f0ba4abb33640205f38e5bee1e981da25175acf

Modified Files
--------------
doc/src/sgml/protocol.sgml          |    2 +-
src/backend/replication/walsender.c |    2 +-
2 files changed, 2 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Michael Meskes
Date:
Subject: pgsql: This routine was calling ecpg_alloc to allocate to memory but di
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Report WAL flush, not insert, position in replication IDENTIFY_S