<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
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. <br>
<br>
Current log listing:<br>
[postgres(at)db01pri pgwalarchives]# ls -ltr<br>
total 82028<br>
-rw------- 1 postgres postgres 250 Jun 15 02:05
0000000400000745000000DB.00F290D8.backup<br>
-rw------- 1 postgres postgres 250 Jun 15 13:28
000000040000074700000065.00D48908.backup<br>
-rw------- 1 postgres postgres 16777216 Jun 15 15:58
0000000400000747000000E4<br>
-rw------- 1 postgres postgres 16777216 Jun 15 15:59
0000000400000747000000E5<br>
-rw------- 1 postgres postgres 16777216 Jun 15 16:02
0000000400000747000000E6<br>
-rw------- 1 postgres postgres 16777216 Jun 15 16:04
0000000400000747000000E7<br>
-rw------- 1 postgres postgres 16777216 Jun 15 16:07
0000000400000747000000E8<br>
[postgres(at)db01pri pgwalarchives]# <br>
<br>
Keith<br>
<br>
Tom Lane wrote:
<blockquote cite="mid:23753(dot)1245096087(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">Keith Pierno <a class="moz-txt-link-rfc2396E" href="mailto:kpierno(at)lulu(dot)com"><kpierno(at)lulu(dot)com></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->
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
</pre>
</blockquote>
<br>
</body>
</html>