Re: BUG #4854: Problems with replaying WAL files on Warm Standby

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Keith Pierno <kpierno(at)lulu(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4854: Problems with replaying WAL files on Warm Standby
Date: 2009-06-15 23:35:07
Message-ID: 27715.1245108907@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Keith Pierno <kpierno(at)lulu(dot)com> writes:
> The backup used was from well after the failover time which is why I
> was concerned. Interestingly enough the logs are still all prefixed
> with 00000004... That just makes this problem extremely bizarre.

Hmm, that *is* weird. It seems like the new primary must have reverted
its decision to go from timeline 4 to timeline 6. (Which in itself is
a bit odd; why not timeline 5?)

Can you give us an exact sequence of events on the slave server/new
primary around the time of the failover? Also, what was in the .history
file when you found it, and are there any other history files?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jim Michaels 2009-06-16 06:58:12 BUG #4855: Explain errors on drop table if exists
Previous Message Keith Pierno 2009-06-15 20:12:19 Re: BUG #4854: Problems with replaying WAL files on Warm Standby