From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | amir(dot)rohan(at)mail(dot)com |
Cc: | PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13644: 2xRecovery without new writes, causes archiving failure |
Date: | 2015-09-26 11:39:11 |
Message-ID: | CAB7nPqTyhwWAFmArf-8C32CRh+aRCx4k=cgw2686fnDfSEpTkw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Sat, Sep 26, 2015 at 12:22 PM, Amir Rohan wrote:
> DETAIL: The failed archive command was: test ! -f
> /var/lib/pgsql/archive/00000002.history && cp pg_xlog/00000002.history
> /var/lib/pgsql/archive/00000002.history
That's a symptom that the second node already selected timeline 2, my
first guess is that the restore_command for the second node recovered
failed to get 00000002.history because it may have been set
incorrectly.
> I expected the last server to create timeline 3, but it looks as if it
> thinks it's timeline2. While in terms of data it's at the same WAL point,
> in terms of events, it should be at timeline 3. That's what I make
> of it anyway.
I am not able to see any problems with neither 9.5 nor HEAD, when
recovering the second node in your scenario, it fetches correctly
00000002.history from the archive in my case and the node is able to
select the timeline 3 when recovery is pointing to select the latest
timeline.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Amir Rohan | 2015-09-26 21:03:58 | Re: BUG #13644: 2xRecovery without new writes, causes archiving failure |
Previous Message | Amir Rohan | 2015-09-26 06:27:50 | Re: BUG #13642: no backup_label file in PG_DATA after pg_stop_backup(); |