On 2018-07-12 19:22:50 -0700, Christophe Pettus wrote: > > > On Jul 12, 2018, at 17:52, Michael Paquier <mich...@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 during startup 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