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