Drop pre-existing subscriptions from the converted subscriber. We don't need the pre-existing subscriptions on the newly formed subscriber by using pg_createsubscriber. The apply workers corresponding to these subscriptions can connect to other publisher nodes and either get some unwarranted data or can lead to ERRORs in connecting to such nodes.
Author: Kuroda Hayato Reviewed-by: Amit Kapila, Shlok Kyal, Vignesh C Backpatch-through: 17 Discussion: https://postgr.es/m/osbpr01mb25526a30a1fbf863accdda3af5...@osbpr01mb2552.jpnprd01.prod.outlook.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/4867f8a555cea1bc6de1726b0030896aa4cd3c70 Modified Files -------------- src/bin/pg_basebackup/pg_createsubscriber.c | 111 ++++++++++++++++++++- src/bin/pg_basebackup/t/040_pg_createsubscriber.pl | 14 +++ 2 files changed, 120 insertions(+), 5 deletions(-)
