Re: Race condition with restore_command on streaming replica

2020-11-18 Thread Leo Jin
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

RE: Race condition with restore_command on streaming replica

2020-11-17 Thread Brad Nicholson
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

Re: Race condition with restore_command on streaming replica

2020-11-15 Thread Dilip Kumar
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