Drop pre-existing subscriptions from the converted subscriber.
authorAmit Kapila <akapila@postgresql.org>
Tue, 2 Jul 2024 05:50:06 +0000 (11:20 +0530)
committerAmit Kapila <akapila@postgresql.org>
Tue, 2 Jul 2024 05:50:06 +0000 (11:20 +0530)
commit622cb84d69be91931568bee180cae7c484a7f026
tree60dfd598c9353fc69d2285966007185976fb3edc
parentca522e2a896cf65339fd24e1e80eb8dcf6ad6729
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: http://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