Re: requested timeline ... does not contain minimum recovery point ...

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: requested timeline ... does not contain minimum recovery point ...
Date: 2018-07-13 02:38:45
Message-ID: 4D11AF05-2E36-4942-8E71-50B234852687@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> On Jul 12, 2018, at 19:22, Christophe Pettus <xof(at)thebuild(dot)com> wrote:
>
>
>> On Jul 12, 2018, at 17:52, Michael Paquier <michael(at)paquier(dot)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.

That being said, the pg_rewind output seems to indicate that the old divergence point was still being picked up, rather than the 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(at)thebuild(dot)com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ideriha, Takeshi 2018-07-13 02:46:54 RE: ON CONFLICT DO NOTHING on pg_dump
Previous Message Masahiko Sawada 2018-07-13 02:28:01 Re: pg_create_logical_replication_slot returns text instead of name