Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
Date
Msg-id CAA4eK1+29FG0HKujGExSoOx+ZMh4JptuRhLufhswa7X2WxYd_w@mail.gmail.com
Whole thread Raw
In response to Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
List pgsql-hackers
Tree view 
On Tue, Mar 11, 2025 at 6:02 AM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> Can you briefly recap how this is different than the automatic behavior described in the existing Step 6?
> "Drop publications on the target server that were replicated because they were created before the replication start
location.It has no use on the subscriber." 
>

These are the publications this tool has created on publisher to make
standby a subscriber, but they have replicated to standby before the
standby is converted to subscriber. As per my understanding, the patch
gives an option to remove publications that are pre-existing (aka not
created by this tool).

--
With Regards,
Amit Kapila.

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Optimization for lower(), upper(), casefold() functions.
Next
From: "David G. Johnston"
Date:
Subject: Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.