Re: requested timeline ... does not contain minimum recovery point... - Mailing list pgsql-hackers

From Andres Freund
Subject Re: requested timeline ... does not contain minimum recovery point...
Date
Msg-id 20180713025412.cvt5axorqgmo343v@alap3.anarazel.de
Whole thread Raw
In response to Re: requested timeline ... does not contain minimum recovery point...  (Christophe Pettus <xof@thebuild.com>)
Responses Re: requested timeline ... does not contain minimum recovery point...  (Christophe Pettus <xof@thebuild.com>)
List pgsql-hackers
On 2018-07-12 19:22:50 -0700, Christophe Pettus wrote:
> 
> > On Jul 12, 2018, at 17:52, Michael Paquier <michael@paquier.xyz> wrote:
> > Wild guess: you did not issue a checkpoint on the promoted standby
> > before running pg_rewind.
> 
> I don't believe a manual checkpoint was done on the target (promoted standby, new master), but it did one as usual
duringstartup after the timeline switch:
 
> 
> > 2018-07-10 19:28:38 UTC [5068]: [1-1] user=,db=,app=,client= LOG:  checkpoint starting: force
> 
> 
> The pg_rewind was started about 90 seconds later.

Note that that message doesn't indicate a completed checkpoint, just
that one started. Do you see a "checkpoint complete: wrote ..." message
before the rewind started?

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: "Ideriha, Takeshi"
Date:
Subject: RE: ON CONFLICT DO NOTHING on pg_dump
Next
From: "Kato, Sho"
Date:
Subject: How to make partitioning scale better for larger numbers ofpartitions