Horton

Add facility to copy replication slots

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: 9f06d79ef831ffa333f908f6d3debdb654292414
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2019-04-05T21:05:18Z
Releases: 12.0 
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

Files

PathChange+/−
contrib/test_decoding/expected/slot.out modified +234 −0
contrib/test_decoding/sql/slot.sql modified +94 −0
doc/src/sgml/func.sgml modified +41 −0
src/backend/replication/logical/logical.c modified +19 −7
src/backend/replication/slotfuncs.c modified +310 −42
src/backend/replication/walsender.c modified +1 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +35 −0
src/include/replication/logical.h modified +1 −0

Documentation touched

Discussion