pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Drop pre-existing subscriptions from the converted subscriber. 2+ messages / 1 participants [nested] [flat]
* pgsql: Drop pre-existing subscriptions from the converted subscriber. @ 2024-07-02 06:21 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Amit Kapila @ 2024-07-02 06:21 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 ------ 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(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Drop pre-existing subscriptions from the converted subscriber. @ 2024-07-02 06:21 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Amit Kapila @ 2024-07-02 06:21 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-07-02 06:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-07-02 06:21 pgsql: Drop pre-existing subscriptions from the converted subscriber. Amit Kapila <akapila@postgresql.org> 2024-07-02 06:21 pgsql: Drop pre-existing subscriptions from the converted subscriber. Amit Kapila <akapila@postgresql.org>
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