Skip to content
Snippets Groups Projects
  • Heikki Linnakangas's avatar
    2af568c6
    Report WAL flush, not insert, position in replication IDENTIFY_SYSTEM · 2af568c6
    Heikki Linnakangas authored
    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.
    2af568c6
    History
    Report WAL flush, not insert, position in replication IDENTIFY_SYSTEM
    Heikki Linnakangas authored
    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.
protocol.sgml 124.75 KiB