Re: [HACKERS] Replication origins and timelines

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Replication origins and timelines
Дата
Msg-id 20170601013328.s6uc36zbn56zkiux@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] Replication origins and timelines  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: [HACKERS] Replication origins and timelines  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
On 2017-05-31 21:27:56 -0400, Stephen Frost wrote:
> Craig,
> 
> * Craig Ringer (craig@2ndquadrant.com) wrote:
> > TL;DR: replication origins track LSN without timeline. This is
> > ambiguous when physical failover is present since XXXXXXXX/XXXXXXXX
> > can now represent more than one state due to timeline forks with
> > promotions. Replication origins should track timelines so we can tell
> > the difference, I propose to patch them accordingly for pg11.
> 
> Uh, TL;DR, wow?  Why isn't this something which needs to be addressed
> before PG10 can be released?

Huh?  Slots are't present on replicas, ergo there's no way for the whole
issue to occur in v10.


> The further comments in your email seem to state that logical
> replication will just fail if a replica is promoted.  While not ideal,
> that might barely reach the point of it being releasable, but turns it
> into a feature that I'd have a really hard time recommending to
> anyone,

Meh^10


> and are we absolutely sure that there aren't any cases where there might
> be an issue of undetected promotion, leading to the complications which
> you describe?

Yes, unless you manipulate things by hand, copying files around or such.


Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [HACKERS] Replication origins and timelines
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Replication origins and timelines