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

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: requested timeline ... does not contain minimum recovery point...
Дата
Msg-id 4D11AF05-2E36-4942-8E71-50B234852687@thebuild.com
обсуждение исходный текст
Ответ на Re: requested timeline ... does not contain minimum recovery point...  (Christophe Pettus <xof@thebuild.com>)
Список 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 по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: pg_create_logical_replication_slot returns text instead of name
Следующее
От: "Ideriha, Takeshi"
Дата:
Сообщение: RE: ON CONFLICT DO NOTHING on pg_dump