From: Amit Kapila <akapila@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Drop pre-existing subscriptions from the converted subscriber.
Date: Tue, 02 Jul 2024 06:21:07 +0000
Message-ID: <E1sOWt0-003v6r-7N@gemulon.postgresql.org> (raw)
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
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/622cb84d69be91931568bee180cae7c484a7f026
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(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: akapila@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Drop pre-existing subscriptions from the converted subscriber.
In-Reply-To: <E1sOWt0-003v6r-7N@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox