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-0001wU-Dr@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_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/0d36d9f2b9a2178bb19ffbe663e39818f51a0f82

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: Heikki Linnakangas
Date:
Subject: pgsql: Report WAL flush, not insert, position in replication IDENTIFY_S
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Report WAL flush, not insert, position in replication IDENTIFY_S