Skip site navigation (1) Skip section navigation (2)

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 20:01:27
Message-ID: 23753.1245096087@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Keith Pierno <kpierno(at)lulu(dot)com> writes:
> I was able to find the file, which was from the date of the failure
> (Tuesday June 9th). My question is why the backup from this morning
> would all of a sudden require a file from the 9th even though 5 hours
> of logs were able to be applied?

It was apparently busy applying the logs that were from the old primary.
When it got up to the point where the failover occurred, kaboom :-(.
It would have had trouble in any case there because the subsequent log
files are presumably numbered 00000006... instead of 00000004...
Were you getting those shipped over properly from the new primary?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Keith PiernoDate: 2009-06-15 20:12:19
Subject: Re: BUG #4854: Problems with replaying WAL files on Warm Standby
Previous:From: Keith PiernoDate: 2009-06-15 19:53:09
Subject: Re: BUG #4854: Problems with replaying WAL files on Warm Standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group