pgsql: Add facility to copy replication slots - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Add facility to copy replication slots
Date
Msg-id E1hCW5G-0006CL-U2@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add facility to copy replication slots

This allows the user to create duplicates of existing replication slots,
either logical or physical, and even changing properties such as whether
they are temporary or the output plugin used.

There are multiple uses for this, such as initializing multiple replicas
using the slot for one base backup; when doing investigation of logical
replication issues; and to select a different output plugins.

Author: Masahiko Sawada
Reviewed-by: Michael Paquier, Andres Freund, Petr Jelinek
Discussion: https://postgr.es/m/CAD21AoAm7XX8y_tOPP6j4Nzzch12FvA1wPqiO690RCk+uYVstg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9f06d79ef831ffa333f908f6d3debdb654292414

Modified Files
--------------
contrib/test_decoding/expected/slot.out   | 234 ++++++++++++++++++++
contrib/test_decoding/sql/slot.sql        |  94 ++++++++
doc/src/sgml/func.sgml                    |  41 ++++
src/backend/replication/logical/logical.c |  26 ++-
src/backend/replication/slotfuncs.c       | 352 ++++++++++++++++++++++++++----
src/backend/replication/walsender.c       |   1 +
src/include/catalog/catversion.h          |   2 +-
src/include/catalog/pg_proc.dat           |  35 +++
src/include/replication/logical.h         |   1 +
9 files changed, 736 insertions(+), 50 deletions(-)


pgsql-committers by date:

Previous
From: Thomas Munro
Date:
Subject: pgsql: Wake up interested backends when a checkpoint fails.
Next
From: Tom Lane
Date:
Subject: pgsql: Use Append rather than MergeAppend for scanning orderedpartitio