Re: State of pg_createsubscriber - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: State of pg_createsubscriber
Date
Msg-id CAA4eK1+6zgma_Y0wpyvw=D3baht+U+rPSdWeV9ahpg1sSc16Dw@mail.gmail.com
Whole thread Raw
In response to Re: State of pg_createsubscriber  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: State of pg_createsubscriber
List pgsql-hackers
On Wed, May 22, 2024 at 8:02 PM Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Mon, May 20, 2024 at 2:42 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> > Just to summarize, apart from BF failures for which we had some
> > discussion, I could recall the following open points:
> >
> > 1. After promotion, the pre-existing replication objects should be
> > removed (either optionally or always), otherwise, it can lead to a new
> > subscriber not being able to restart or getting some unwarranted data.
> > [1][2].
> >
> > 2. Retaining synced slots on new subscribers can lead to unnecessary
> > WAL retention and dead rows [3].
> >
> > 3. We need to consider whether some of the messages displayed in
> > --dry-run mode are useful or not [4].
>
> Amit, thanks for summarzing your understanding of the situation. Tom,
> is this list complete, to your knowledge? The original thread is quite
> complex and it's hard to pick out what the open items actually are.
> :-(
>
> I would like to see this open item broken up into multiple open items,
> one per issue.
>
> Link [4] goes to a message that doesn't seem to relate to --dry-run.
>

Sorry, for the wrong link. See [1] for the correct link for --dry-run
related suggestion:

[1] https://www.postgresql.org/message-id/CAA4eK1J2fAvsJ2HihbWJ_GxETd6sdqSMrZdCVJEutRZRpm1MEQ%40mail.gmail.com

--
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Ilyasov Ian
Date:
Subject: RE: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled
Next
From: Amit Kapila
Date:
Subject: Re: speed up a logical replica setup