Hi Brad,
We did some research on this at EDB and here is a summary of the finding
and suggested next steps.
*Context:*
*Given* a 3 node cluster M0, M1 and M2.
*And *M0 is the primary with M1 and M2 as the replicas - we will call
this *"T0"
(Timeline 0).*
*And* a *"switch over"* command is issued
Dilip Kumar wrote on 2020/11/15 04:47:12 AM:
> I am not sure how Patroni does it internally, can you explain the
> scenario in more detail? Suppose you are executing the promote on m-1
> and if the promotion is successful it will switch the timeline and it
> will create the timeline history file
On Thu, Nov 5, 2020 at 1:39 AM Brad Nicholson wrote:
>
> Hi,
>
> I've recently been seeing a race condition with the restore_command on
> replicas using streaming replication.
>
> On the primary, we are archiving wal files to s3 compatible storage via
> pgBackRest. In the recovery.conf section o