Thread: pgsql: pg_createsubscriber: Add -R publications option.
pg_createsubscriber: Add -R publications option. This patch introduces a new '-R'/'--remove' option in the 'pg_createsubscriber' utility to specify the object types to be removed from the subscriber. Currently, we add support to specify 'publications' as an object type. In the future, other object types like failover-slots could be added. This feature allows optionally to remove publications on the subscriber that were replicated from the primary server (before running this tool) during physical replication. Users may want to retain these publications in case they want some pre-existing subscribers to point to the newly created subscriber. Author: Shubham Khanna <khannashubham1197@gmail.com> Reviewed-by: Peter Smith <smithpb2250@gmail.com> Reviewed-by: David G. Johnston <david.g.johnston@gmail.com> Reviewed-by: Euler Taveira <euler@eulerto.com> Reviewed-by: Zhijie Hou <houzj.fnst@fujitsu.com> Reviewed-by: vignesh C <vignesh21@gmail.com> Reviewed-by: Nisha Moond <nisha.moond412@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Discussion: https://postgr.es/m/CAHv8RjL4OvoYafofTb_U_JD5HuyoNowBoGpMfnEbhDSENA74Kg@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/e5aeed4b8020424fa882c3d1969d00c2b2d8cf30 Modified Files -------------- doc/src/sgml/ref/pg_createsubscriber.sgml | 23 +++++ src/bin/pg_basebackup/pg_createsubscriber.c | 105 ++++++++++++++++++--- src/bin/pg_basebackup/t/040_pg_createsubscriber.pl | 25 ++++- 3 files changed, 136 insertions(+), 17 deletions(-)