public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nikolay Samokhvalov <[email protected]>
To: [email protected]
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Subject: Re: Using old master as new replica after clean switchover
Date: Thu, 25 Oct 2018 14:10:02 -0700
Message-ID: <CANNMO+L1MtF3d-7y7pk6H5Wxt=G3ZRQn4QcNNQ0nS-713GxMCw@mail.gmail.com> (raw)
In-Reply-To: <20181025150351.629a68a1@firost>
References: <CANNMO+KYuH3Gh7BZp=UGXpoos4tBR0AFgoONkqWBrokuJthEug@mail.gmail.com>
<20181025111551.620c6460@firost>
<[email protected]>
<20181025150351.629a68a1@firost>
On Thu, Oct 25, 2018 at 6:03 AM Jehan-Guillaume de Rorthais <[email protected]>
wrote:
> What about logging the shutdown checkpoint on the old master?
> On the standby side, we could cross-check it with a function confirming:
> 1/ the very last XLogRecord received was the old master shutdown checkpoint
> 2/ the received shutdown checkpoint has the same LSN
>
Additionally, the new instructions in the doc might include recommendation,
what to do if we
found that shutdown checkpoint wasn't received and replayed by the
replica-to-promote. From my
understanding, before promotion, we could "manually" transfer missing WAL
data from the old,
inactive master and replay it on the replica-to-promote (of course, if
recovery_command is
properly configured on it). Right?
By the way, if it looks to me that it might be better to write more than
just few sentences, what if it
will be a new chapter – say, "Switchover", next to "Failover". It would
also give better understanding
to the reading, explicitly distinguishing planned and unplanned processes
of master/replica role
changes.
Regards,
Nik
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Using old master as new replica after clean switchover
In-Reply-To: <CANNMO+L1MtF3d-7y7pk6H5Wxt=G3ZRQn4QcNNQ0nS-713GxMCw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox