requested timeline doesn't contain minimum recovery point

From: Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: requested timeline doesn't contain minimum recovery point
Date: 2017-01-05 16:01:22
Message-ID: CAK77FCQh0U-L8sr7r18bOuyfYRnE_agfFxksBNMWscbOT1Qhug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
there is something happening in my replication that is not clear to me. I
think I'm missing something.
I've two server, red and blue.
red is primary blue is standby, async repl.
Now:
1 cleanly stop red
2 promote blue
3 insert tuples in blue
4 from red site, pg_rewind from blue to red dir.
5 start red as standby-> OK
6 wait a long time and then cleanly stop blue
7 promote red
8 insert tuples in red
9 from blue site, pg_rewind from red to blue dir
10 start blue as standby -> I get "requested timeline 3 doesn't contain
minimum recovery point 1/... on timeline 1

Sometimes this "switching game" works up to timeline 4 or 5, not always 3

Regards
Pupillo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2017-01-05 16:21:00 Re: Postgresql query HAVING do not work
Previous Message Adrian Klaver 2017-01-05 15:01:43 Re: COPY: row is too big