Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical
Дата
Msg-id CAKFQuwbOz9x-dQFxUnw3sdpGL4WrJB4m051yGyAOrV4Csj2iFA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical  (Sasa Vilic <sasavilic@gmail.com>)
Ответы Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical
Список pgsql-general
It is customary to inline or bottom-posts on these lists.  Please follow the example of those responding to your emails.

On Mon, Feb 27, 2017 at 6:45 PM, Sasa Vilic <sasavilic@gmail.com> wrote:
And also this:

"""
If archive_mode is set to on, the archiver is not enabled during recovery or standby mode. If the standby server is promoted, it will start archiving after the promotion, but will not archive any WAL it did not generate itself. To get a complete series of WAL files in the archive, you must ensure that all WAL is archived, before it reaches the standby
"""

If I understand it correctly, WAL started on master but finished on standby (after failover) will still not be (old master is presumably dead and new master must wait for next WAL segment). Of course, the next WAL segment will be sent by new master, but we are going to miss exactly this one WAL segment during which failover occurred and thus introduce interruption in our WAL stream. Am I right?

​Requires knowledge and familiarity I present lack.  Sorry.  I think I see where you are going with all of this but it would probably help to explicitly state the overall concern or plan and not just ask how specific mechanics work in isolation.

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical
Следующее
От: Sasa Vilic
Дата:
Сообщение: Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical