pgsql: Add confirmed_flush column to pg_replication_slots.

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add confirmed_flush column to pg_replication_slots.
Date: 2015-08-10 11:29:20
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(dot)1020109(at)joh(dot)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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2015-08-10 11:29:22 pgsql: Don't start to stream after pg_receivexlog --create-slot.
Previous Message Christoph Berg 2015-08-10 11:00:38 Using contrib modules in check (Re: pgsql: Fix BRIN to use SnapshotAny during summarization)