Re: State of pg_createsubscriber

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: State of pg_createsubscriber
Дата
Msg-id CAA4eK1+6zgma_Y0wpyvw=D3baht+U+rPSdWeV9ahpg1sSc16Dw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: State of pg_createsubscriber  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: State of pg_createsubscriber
Список 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 по дате отправления:

Предыдущее
От: Ilyasov Ian
Дата:
Сообщение: RE: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: speed up a logical replica setup