Drop pre-existing subscriptions from the converted subscriber.
authorAmit Kapila <akapila@postgresql.org>
Tue, 2 Jul 2024 06:06:21 +0000 (11:36 +0530)
committerAmit Kapila <akapila@postgresql.org>
Tue, 2 Jul 2024 06:06:21 +0000 (11:36 +0530)
commit4867f8a555cea1bc6de1726b0030896aa4cd3c70
tree040fe857306b2612e91d05b7003055b906499b7a
parent8f8bcb88833eecfffbbb0d048ff0b6c33e64f7ce
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/OSBPR01MB25526A30A1FBF863ACCDDA3AF5C92@OSBPR01MB2552.jpnprd01.prod.outlook.com
src/bin/pg_basebackup/pg_createsubscriber.c
src/bin/pg_basebackup/t/040_pg_createsubscriber.pl