Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Shubham Khanna <khannashubham1197(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Euler Taveira <euler(at)eulerto(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
Date: 2025-06-25 09:01:43
Message-ID: a20fb15d-abee-40e6-a0c4-81b1fe3a0799@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 23.06.25 05:48, Hayato Kuroda (Fujitsu) wrote:
> Thanks for posting the patch. Largely it seems OK.

Thanks, I have committed this.

> One comment:
> I feel most of the word "remove" can be changed to "dropped", in pg_createsubscriber.c
> and 040_pg_createsubscriber.pl. E.g.,
>
> ```
> # Confirm the physical replication slot has been removed
> $result = $node_p->safe_psql($db1,
> "SELECT count(*) FROM pg_replication_slots WHERE slot_name = '$slotname'"
> );
> is($result, qq(0),
> 'the physical replication slot used as primary_slot_name has been removed'
> );
> ```
>
> And
>
> ```
> /* Remove failover replication slots if they exist on subscriber */
> drop_failover_replication_slots(dbinfos.dbinfo);
> ```

These are from areas unrelated to this patch or the original patch that
introduced this feature, so it felt out of scope to touch those at this
point. I don't feel strongly about the need to wipe out all uses of the
word "remove". It's okay to be a bit flexible in code comments and
other less prominent places, I think.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2025-06-25 09:22:41 Re: pgsql: Introduce pg_shmem_allocations_numa view
Previous Message Christoph Berg 2025-06-25 09:00:38 Re: pgsql: Introduce pg_shmem_allocations_numa view