Drop pre-existing subscriptions from the converted subscriber.

Amit Kapila <akapila@postgresql.org>

Commit: 622cb84d69be91931568bee180cae7c484a7f026
Author: Amit Kapila <akapila@postgresql.org>
Date: 2024-07-02T05:50:06Z
Releases: 17.0
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

Files

Discussion