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

From Christophe Pettus
Subject Re: requested timeline ... does not contain minimum recovery point...
Date
Msg-id 4D11AF05-2E36-4942-8E71-50B234852687@thebuild.com
Whole thread Raw
In response to Re: requested timeline ... does not contain minimum recovery point...  (Christophe Pettus <xof@thebuild.com>)
List pgsql-hackers
> On Jul 12, 2018, at 19:22, Christophe Pettus <xof@thebuild.com> 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.

That being said, the pg_rewind output seems to indicate that the old divergence point was still being picked up, rather
thanthe one on timeline 104: 

> servers diverged at WAL position A58/50000000 on timeline 103
> rewinding from last common checkpoint at A58/4E0689F0 on timeline 103

--
-- Christophe Pettus
   xof@thebuild.com



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: pg_create_logical_replication_slot returns text instead of name
Next
From: "Ideriha, Takeshi"
Date:
Subject: RE: ON CONFLICT DO NOTHING on pg_dump