pgsql: Add confirmed_flush column to pg_replication_slots. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Add confirmed_flush column to pg_replication_slots.
Date
Msg-id E1ZOlGa-0001pQ-JL@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add confirmed_flush column to pg_replication_slots.

There's no reason not to expose both restart_lsn and confirmed_flush
since they have rather distinct meanings. The former is the oldest WAL
still required and valid for both physical and logical slots, whereas
the latter is the location up to which a logical slot's consumer has
confirmed receiving data. Most of the time a slot will require older
WAL (i.e. restart_lsn) than the confirmed
position (i.e. confirmed_flush_lsn).

Author: Marko Tiikkaja, editorialized by me
Discussion: 559D110B.1020109@joh.to

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/3f811c2d6f51b13b71adff99e82894dd48cee055

Modified Files
--------------
contrib/test_decoding/expected/ddl.out |    4 ++--
doc/src/sgml/catalogs.sgml             |   11 +++++++++++
doc/src/sgml/high-availability.sgml    |    6 +++---
doc/src/sgml/logicaldecoding.sgml      |    8 ++++----
src/backend/catalog/system_views.sql   |    3 ++-
src/backend/replication/slotfuncs.c    |    9 ++++++++-
src/include/catalog/catversion.h       |    2 +-
src/include/catalog/pg_proc.h          |    2 +-
src/test/regress/expected/rules.out    |    5 +++--
9 files changed, 35 insertions(+), 15 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Don't start to stream after pg_receivexlog --create-slot.
Next
From: Andres Freund
Date:
Subject: pgsql: Don't start to stream after pg_receivexlog --create-slot.