RE: pg_createsubscriber: drop pre-existing subscriptions from the converted node - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: pg_createsubscriber: drop pre-existing subscriptions from the converted node
Date
Msg-id OSBPR01MB25522868FB47DF5808597D8CF5D32@OSBPR01MB2552.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node
Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node
List pgsql-hackers
Dear Amit,

Thanks for giving comments! PSA new version.

> Thanks, this is a better approach. I have changed a few comments and
> made some other cosmetic changes. See attached.

I checked your attached and LGTM. Based on that, I added some changes
like below:

- Made dbname be escaped while listing up pre-existing subscriptions
 Previous version could not pass tests by recent commits.
- Skipped dropping subscriptions in dry_run mode
  I found the issue while poring the test to 040_pg_createsubscriber.pl.
- Added info-level output to follow other drop_XXX functions

> BTW, why have you created a separate test file for this test? I think
> we should add a new test to one of the existing tests in
> 040_pg_createsubscriber.

I was separated a test file for just confirmation purpose, I've planned to merge.
New patch set did that.

> You can create a dummy subscription on node_p
> and do a test similar to what we are doing in "# Create failover slot
> to test its removal".

Your approach looks better than mine. I followed the approach.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED
https://www.fujitsu.com/ 


Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Assertion failure with summarize_wal enabled during pg_createsubscriber
Next
From: Masahiko Sawada
Date:
Subject: Re: Conflict Detection and Resolution